mark duplicate entries
 

I have multiple rows of data with eight columns (A1:H1). I would like to be
able to find which rows are duplicated in column A, D, E and G.
I know I can sort these by and separate any data that doesn't match but I
would like to work with something a little more quicker.

mark duplicate entries
 

In other words:
A10 contains 12345 D10 contains 11/3/2007 E10 contains xyz G10 contains abc
this is duplicated in
A801 contains 12345 D801 contains 11/3/2007 E801 contains xyz G801 contains
abc


"Bob" wrote:

I have multiple rows of data with eight columns (A1:H1). I would like to be
able to find which rows are duplicated in column A, D, E and G.
I know I can sort these by and separate any data that doesn't match but I
would like to work with something a little more quicker.

mark duplicate entries
 

=SUMPRODUCT(($A$10:$A$1000=A10)*($D$10:$D$1000=D10 )*($E$10:$E$1000=E10)*($G$10:$G$1000=G10))1

copy down as far as needed

TRUE for duplicate
FALSE for not duplicate


"Bob" wrote:

In other words:
A10 contains 12345 D10 contains 11/3/2007 E10 contains xyz G10 contains abc
this is duplicated in
A801 contains 12345 D801 contains 11/3/2007 E801 contains xyz G801 contains
abc


"Bob" wrote:

I have multiple rows of data with eight columns (A1:H1). I would like to be
able to find which rows are duplicated in column A, D, E and G.
I know I can sort these by and separate any data that doesn't match but I
would like to work with something a little more quicker.

mark duplicate entries
 

Beautiful.

Thank you.

"Teethless mama" wrote:

=SUMPRODUCT(($A$10:$A$1000=A10)*($D$10:$D$1000=D10 )*($E$10:$E$1000=E10)*($G$10:$G$1000=G10))1

copy down as far as needed

TRUE for duplicate
FALSE for not duplicate


"Bob" wrote:

In other words:
A10 contains 12345 D10 contains 11/3/2007 E10 contains xyz G10 contains abc
this is duplicated in
A801 contains 12345 D801 contains 11/3/2007 E801 contains xyz G801 contains
abc


"Bob" wrote:

I have multiple rows of data with eight columns (A1:H1). I would like to be
able to find which rows are duplicated in column A, D, E and G.
I know I can sort these by and separate any data that doesn't match but I
would like to work with something a little more quicker.