Hi,
I want to compare if Column A cells are in Column B.
EG.
ColumnA ||| ColumnB ||| ColumnC
Ru ||| Mark ||| False
Mark ||| Zee ||| True
And column C returns the answer as true or false.
Hope you can help.
Thank you
Ruby
Hi,
I want to compare if Column A cells are in Column B.
EG.
ColumnA ||| ColumnB ||| ColumnC
Ru ||| Mark ||| False
Mark ||| Zee ||| True
And column C returns the answer as true or false.
Hope you can help.
Thank you
Ruby
Try
pasted into C1 and copied downPlease Login or Register to view this content.
Martin
Or, C1 copy down.
=ISNUMBER(MATCH(A1,B:B,0))
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks