Thread: Marking Dupes
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GregR GregR is offline
external usenet poster
 
Posts: 246
Default 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