Matching two columns
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
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
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.
Are the 500 names unique?
Yes, all the names in column B are unique, but they have a matching name in column A
In that case, you could create a new column and put in this formula:
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.
Still gives me error when i try to use this
What error do you get?