Marking Dupes

From: "GregR" <gregrivet@xxxxxxxxx>
Date: 9 Jan 2006 08:54:46 -0800

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

.

Follow-Ups:
- Re: Marking Dupes
  - From: Tom Ogilvy

Prev by Date: Re: HOW TO: Name Range?
Next by Date: Re: combining two worksheets into one
Previous by thread: combining two worksheets into one
Next by thread: Re: Marking Dupes
Index(es):
- Date
- Thread