View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
wyaj wyaj is offline
external usenet poster
 
Posts: 1
Default 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??