Duplicate Entries

[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

 

[Frank Kabel]

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