Thread: match values

yes !! It works Thanks you so much, this will make my work so much easier. Absolutely awesome

Wouldn't the quickest way to do this be,

Copy and paste row A with the 1000 customers names into a different tab, E.g Sheet 2
then Instert a coloum next to coloum B, Use a Vlookup, =VLOOKUP(B1,Sheet2!,A1:A1000,True,False) On the A1:A1000 you wil need to highlight them both and click F4, Then all you do is drag all the way to the bottom

Then Filter Largest to smallest all the people with N/A are not on the list and can be deleted and the people you are left with will be on both list,

And then If you need all 3 coloums in one spreadsheet open up a new one and copy using Right click paste speacial options then values has the picture 1,2,3 hope this is what you were looking for

Thanks