Hi all,
I have a spreadsheet with a list of data in column A
I am looking for a formula that I can use on data I put in column B to delete cells that are the same as any cell in column A
E.G
Column A
hello
data
hotel
mind
them
Column B
farm
wonder
hello
them
So, basically, I enter a formula in column C, copy down, and I would be left with 'farm' and 'wonder' in Column C.
Hope that makes sense!
Thanks for any help on this.
Bookmarks