P
Patsy
I have this if statement from Franks that work fine. However th
results are does not match up.
Meaning the where the Duplicate field is in A4 the results are shown i
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 Harle
results are does not match up.
Meaning the where the Duplicate field is in A4 the results are shown i
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 Harle