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