| 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 |
| 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) | |||
Threaded Mode
