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

=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

Thanks Tom, but then I tried to count the values in Col "B" with "TRUE"
and the result is 0, I expected 1. The formula I used was
countif($B$1:$B$100,"TRUE"), where there is 1 TRUE Value in the range.
TIA

Greg

That isn't anything like the formula I gave you:

=if(countif($B$1:$B1,$B1)1,True,False)

or if you want the text values True and False rather than the boolean values
=if(countif($B$1:$B1,$B1)1,"True","False")

put in C1, then drag fill down to C100

--
Regards,
Tom Ogilvy


"GregR" wrote in message
ups.com...
Thanks Tom, but then I tried to count the values in Col "B" with "TRUE"
and the result is 0, I expected 1. The formula I used was
countif($B$1:$B$100,"TRUE"), where there is 1 TRUE Value in the range.
TIA

Greg

Tom, sorry for the misunderstanding. What you gave me was perfect. What
I further want to do is, as a result of your formula, to now count the
values in B1:B100 that are returned as "True". The formula I used was
countif($B$1:$B$100,"TRUE"), where there is 1 TRUE Value in the range.

=COUNTIF(B:B,"*TRUE*")

Possibly. It migh be easier change the orginal to be

True,False) rather than "True","False")

then use

=Countif(B:B,True)



--
Regards,
Tom Ogilvy


"GregR" wrote in message
oups.com...
Tom, sorry for the misunderstanding. What you gave me was perfect. What
I further want to do is, as a result of your formula, to now count the
values in B1:B100 that are returned as "True". The formula I used was
countif($B$1:$B$100,"TRUE"), where there is 1 TRUE Value in the range.