=IF(COUNTIF($A$1:$A1,$A1)1,"TRUE","FALSE")

in B1 for example, then drag fill down the column

--
Regards,
Tom Ogilvy


"GregR" wrote in message
oups.com...
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