Hello,
I have long list in the column A and a bit shorter one in the B. Column A contains all entries that are in the column B plus additional ones.
I would like to filter list A to show only that is unique for that column and to exclude entries that are in column B as well.
Simple example, let say that Column A has this entries:
Blue
Red
Yellow
Green
Orange
Black
White
And column B has
Blue
Red
I would like then to see in the column C for example
Yellow
Green
Orange
Black
White
Thanks in advance for help, I am sure that this is something relatevily easy to sort out (I did try some lookup methods but it didn't work)
Bookmarks