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

Data Compare
 

If
=SUMPRODUCT((M1:M1000=D2)*(N1:N1000=E2))
is greater than 0, then the match exits somewhere in the columns

AutoFilter can tell you exactly where the match(es) occur.
--
Gary''s Student - gsnu200820


"SiH23" wrote:

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