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