Hi Redragon,

no problem, thanks for the feedback :-)

We have said that the countif function is simpler because it just
involves the use of a single function (ie "countif") rather than using
two different functions together as my solution did (ie "isnumber" &
"match").

Also, it looks neater/shorter, ie consider
=COUNTIF($A$2:$A$7,B2)0
compared to,
=ISNUMBER(MATCH(B2,$A$2:$A$7,0))

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=537442