r/excel•
TrMaxEst

Matching two columns

unsolved

I have to match colum B to column A. I have around 4000 names in column A and 500 names in column B i need column be to be sorted so the names in column B are behind the names in column A

Posted Dec 9, 2014, 6:46 PM UTC

27
elguapo199141•

Are the 500 names unique?

1
TrMaxEstOP•

Yes, all the names in column B are unique, but they have a matching name in column A

1
elguapo199141•

In that case, you could create a new column and put in this formula:

=IF(NOT(ISERROR(MATCH($A1,$B:$B,0))),$A1,"")

If you're looking to replace the data in B, simply copy and paste special the values from your new column to column B, then delete the new one.

1
TrMaxEstOP•

Still gives me error when i try to use this

1
elguapo199141•

What error do you get?

1
LaughingRage51•

How about putting another column in between A and B as a helper column. In cell B2 put this formula and then drag down:

=COUNTIF(C:C,A2)

Then you can filter by the ones that match and sort them however youd like.

1