How matchup many IDdata- find matched IDdata in long columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to find which cells in one column contain the same identifying
numbers in a second column.

'Have used individual search/find but there's hundreds -- and the project is
continuing.

VLookup was suggested, but appears to also only search for 1-at-a-time.
Pivottable was suggested, but does not appear to match at all.

What works??
 
Data>filter>autofilter or advanced filter


--


Regards,


Peo Sjoblom
 
Assuming source data running in cols A and B, from row2 down
and you want to check col A's values with what's listed in col B

In C2: =IF(A2="","",ISNUMBER(MATCH(A2,B:B,0)))
Copy down to the last row of data in col A. Then apply autofilter on col C,
filter out TRUE from the autofilter droplist in C1.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

matching columns to find differences. 0
return proper match from three columns 2
With F1 value, look at A, if match or partial match return B 5
Matching column criteria in a one to many relationship 8
Index and Match 8
Vlookup to find a match in a string 6
Finding the largest match 9
Finding matches in two columns 4

Back
Top