Looking for Excel Formula
 

Attention Excel Gurus,

I had a formula once that searched through a range of text and if it
found a duplicate it marked the cell 0 if it was the first or only
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'm
talking about?

Thanks

JHorsley


--
jhorsley
------------------------------------------------------------------------
jhorsley's Profile: http://www.excelforum.com/member.php...o&userid=26040
View this thread: http://www.excelforum.com/showthread...hreadid=393876

Try this:

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

copy down your range as needed

Good Luck

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=393876