Re: Marking Dupes

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" <gregrivet@xxxxxxxxx> wrote in message
news:1136830475.103144.72270@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> 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
>


.

Relevant Pages