Cell content elimination; duplicate

  • Thread starter Thread starter BudD
  • Start date Start date
B

BudD

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
 

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

Duplicate lines in spreadsheet 1
complex sort search and replace macro 2
Finding Duplicates 4
Finding duplicates 2
List Duplicates 4
Remove Rows That Are NOT Duplicates 4
Find duplicate, but only if an adjacent cell is identical 2
Remove Duplicates logic 2

Back
Top