View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Funky[_2_] Funky[_2_] is offline
external usenet poster
 
Posts: 1
Default if statement or other methds to find similar data

Hello

I have two set of data. I have to match that both contain PCO12345.
All PCO# # # # are different. Majority are in both files but some of
the them are missing. There is no particular order. Is there any way
to find PCO # # # # that are in both files and which ones are
missing? I there any easy method like if statements? other than going
through each finding each PCOnumber one by one. There are 2300+
recods.

thanks in advance