Referencing Two Tables

  • Thread starter Thread starter RedFive
  • Start date Start date
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
 
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
 
Back
Top