Duplicate searching through multiple columns, rows

  • Thread starter Thread starter Eliezer
  • Start date Start date
E

Eliezer

I just did a search through the newsgroup but didn't find
anything specific to this. I'm trying to look for
duplicates so that it would recognize ROWS A and C as
being duplicate (see below). Is there any way to do that?

1 2 3 4 5

A 1 2 1 5 6
B 1 2 1 6 3
C 1 2 1 5 6
D 2 2 3 6 4

This is basically going to an access database, removing
the primary key, and asking that if this happens which
entries are duplicate. It would be REALLY excellent if I
could know which rows were duplicate to which rows, but
all I need for now is just to find the duplicates. Thanks!
 
Hi Eliezer
one way (not elegant but working:-)
Add a helper column (column F) next to the last column and combine the
entries of the matrix (I assume you hvae switched the naming of
row/columns in your example somehow). Enter the following in F1
=A1&B1&C1&D1&E1
copy down
In the next helper column (column G) enter the following in G1
IF(SUMIF($E$1:$E$999,E1)>1,"Duplicate", "OK")

HTH
Frank
 
Back
Top