Duplicate Entries

  • Thread starter Thread starter harley
  • Start date Start date
H

harley

I'm Tagging Duplicate Entries in my excel Spreadsheet.

The problem I am having,
I have 4 columns of data I have to match up. and if all 4 columns matc
up show "dup" in Column A else show "blank" or "No Dup"

sure I can make this work for one column that I defined the rang
called Range1
=IF(COUNTIF(Range1,???)>1,"Dup","NoDup")

or using no defined ranges
=COUNTIF(A1:A10,"value")

Is there a way to detect multiple column or row and if all are the sam
display dup in Column A???

Thanks in advance

Pam
 
Hi
lets assume your data is in columns B1:E100. Now use the following
formula in A1:
=IF(SUMPRODUCT(--($B$1:$B1=B1),--($C$1:$C1=C1),--($D$1:$D1=D1),--($E$1:
$E1=E1))>1,"Dup","")
and copy this down for all rows
 
Back
Top