Re: Marking Dupes
- From: "Tom Ogilvy" <twogilvy@xxxxxxx>
- Date: Mon, 9 Jan 2006 11:58:04 -0500
=IF(COUNTIF($A$1:$A1,$A1)>1,"TRUE","FALSE")
in B1 for example, then drag fill down the column
--
Regards,
Tom Ogilvy
"GregR" <gregrivet@xxxxxxxxx> wrote in message
news:1136825686.689456.309490@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> 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: GregR
- Re: Marking Dupes
- References:
- Marking Dupes
- From: GregR
- Marking Dupes
- Prev by Date: Re: combining two worksheets into one
- Next by Date: Performing Action On Multiple Values In A Column
- Previous by thread: Marking Dupes
- Next by thread: Re: Marking Dupes
- Index(es):
Loading
