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
|