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