Looking for Excel Formula

[jhorsley]

Attention Excel Gurus,

I had a formula once that searched through a range of text and if i
found a duplicate it marked the cell 0 if it was the first or onl
occurence of the value it returned a 1. it looked something like
=IF(a1, A1:A2 = a1,1,0) But that is not it. Does anyone know what I'
talking about?

Thanks

JHorsle

 

[swatsp0p]

Try this:

=IF($A$1:$A$100=$A$1,1,0)

copy down your range as needed

Good Luck

Bruc