Duplicate fields does not match up! If statement
 

I have this if statement from Franks that work fine. However the
results are does not match up.

Meaning the where the Duplicate field is in A4 the results are shown in
A5 it appears to be one off. How do I correct

Using 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


Thanks
Patsy aka Harley


--
Patsy
------------------------------------------------------------------------
Patsy's Profile: http://www.excelforum.com/member.php...o&userid=16026
View this thread: http://www.excelforum.com/showthread...hreadid=274916