Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
How can I make the bar that shows the content of the cell visible. | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
vlookup to extract part cell content | Excel Discussion (Misc queries) | |||
Transferring cell content between workbooks using cell references | Excel Discussion (Misc queries) |