Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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?? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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?? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to find the number of matched date? | Excel Discussion (Misc queries) | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
How do I matchup this criteria? | Excel Worksheet Functions | |||
Copying matched criteria plus relevant columns to new worksheet | Excel Discussion (Misc queries) |