Cell content elimination; duplicate
 

Hi,
I'm running a helper column, AI, with this formula:
=IF(COUNTIF($A$3:$A$1341,A3)1,"Duplicate","")

Both rows with duplicate information are flagged in AI and
they are always together, lucky me!

Is there a way to eliminate the values in cells in columns
O and P for the second instance (the record duplication)
so as to correct my totals?

TIA

BudD,

An easy way would be to use a SUMIF to subtract half of the values flagged
by the duplicates.

So, adjust your SUM formulas like so

=SUM(O3:O1341) - SUMIF(AI3:AI1341,"Duplicate",O3:O1341)/2

and again for column P.

HTH,
Bernie
MS Excel MVP



"BudD" wrote in message
...
Hi,
I'm running a helper column, AI, with this formula:
=IF(COUNTIF($A$3:$A$1341,A3)1,"Duplicate","")

Both rows with duplicate information are flagged in AI and
they are always together, lucky me!

Is there a way to eliminate the values in cells in columns
O and P for the second instance (the record duplication)
so as to correct my totals?

TIA