How matchup many IDdata- find matched IDdata in long columns
 

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??

How matchup many IDdata- find matched IDdata in long columns
 

Datafilterautofilter or advanced filter


--


Regards,


Peo Sjoblom



"wyaj" wrote in message
...
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??

How matchup many IDdata- find matched IDdata in long columns
 

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"wyaj" wrote:
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??