Referencing Two Tables

R

RedFive

I am trying to take two different tables and find all the examples that don't
match exactly in three different columns. If they match in one or two but
not all three I would like to display that entry. If it does match exactly
in all three columns, it could just be ignored. Does anybody know the best
way to do this? Thanks
 
G

Gary''s Student

Say we have data in cols A & B & C.

In D1 enter:

=(A1=B1)+(B1=C1) and copy down

The values in column D will be either 0,1,2
To hide rows where all are equal, set an AutoFilter to not equal 2
 
Top