Referencing Two Tables
 

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

Referencing Two Tables
 

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
--
Gary''s Student - gsnu200817


"RedFive" wrote:

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