Hi,

Can somebody help me on which function do i have to use.

1. I need to count the number of (example 22403248 equivalent to
ANSWER)

then answer should be 3

22403248 ANSWER
22456987 ANSWER
456321547 NO ANSWER
459874561 NO ANSWER
441254789 NO ANSWER
449874562 NO ANSWER
456589874 NO ANSWER
22409874 ANSWER


hoping to get response ..
thank you


--
mye0417
------------------------------------------------------------------------
mye0417's Profile: http://www.excelforum.com/member.php...o&userid=26124
View this thread: http://www.excelforum.com/showthread...hreadid=396756