Thread: Data Compare
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SiH23 SiH23 is offline
external usenet poster
 
Posts: 48
Default Data Compare

Is it possible in excel to run a search that checks if the details in 2 cells
of a row occur together again in the any row but different columns. for
instance:

D2 = JOE
E2 = BLOGGS

Check if JOE is present anywhere in column M with BLOGGS also present in
that same row in column N