Data Compare

  • Thread starter Thread starter SiH23
  • Start date Start date
S

SiH23

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicates in Rows 4
how do you look up a name in a worksheet 3
Payroll,formulas and Macros? 2
Auto sum 2 adjacent row data into 3rd row? 1
subtotal data from 2 columns into 3rd column 1
Data Compare 5
Splitting Text strings in one cell 1
Auto merging existing contacts 0

Back
Top