Duplicate fields does not match up! If statement

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

problem with time subtraction 7
concantenate then index match 2
column to row draging 1
Separating equal values 2
Different Functions in One Cell Cancel Each Other Out - How can I fix this? 1
Look up or Match Function? Excuse my ignornace. This could be simple.Variable Upgrades on Furniture 1
Very strange behaviour of VLOOKUP in Excel 2010 4
another sumproduct with #value error... 5

Top