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
|