| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Marking Dupes
I have this formula: =IF(COUNTIF($A:$A,$A871)1,"TRUE","FALSE"), which
works OK, but I only want the second instance of the dupe marked as false not the first. In other words with this formula, if there are 2 instances of 1000 in COL "A", the formula column shows TRUE for both. I want FALSE for the 1st instance and TRUE for the 2nd. TIA Greg |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup & sum? or maybe summing dupes? | Excel Discussion (Misc queries) | |||
| macro for dupes | Excel Discussion (Misc queries) | |||
| Checking for Dupes | Excel Discussion (Misc queries) | |||
| deleting dupes/certain values | Excel Programming | |||
| delete dupes in column | Excel Programming | |||
Threaded Mode
