I have two columns of numbers, and I need to find matches between column A and B, so I can remove them.
Column A is 57 numbers long, column B is 576 long.
VLookup just confused me, any help appreciated.
I have two columns of numbers, and I need to find matches between column A and B, so I can remove them.
Column A is 57 numbers long, column B is 576 long.
VLookup just confused me, any help appreciated.
Try this in C1 and copy down
=IF(ISNA(MATCH(B1,$A$1:$A$57,0)),"No","Yes")
Last edited by oldchippy; 11-26-2007 at 12:16 PM.
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Try this on C1:
=IF(SUMPRODUCT(--($A$1:$A$57 = B1)) = 1, "DELETE", "RETAIN")
then copy down up to B576, then use AutoFilter, filter DELETE then delete all.
Corine
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks