Hi AP,

Thanks a lot for solution.

But, I confess that I am unable to understand how will this work
because the formula sees only the 2 nd row for counting (A2, B2 etc.).
It will be helpful if you could eductae me on how your solution works..
Sorry if I am sounding very stupid.

Thanks again for your help.

Regards
Anand


--
anandmr65
------------------------------------------------------------------------
anandmr65's Profile: http://www.excelforum.com/member.php...o&userid=30728
View this thread: http://www.excelforum.com/showthread...hreadid=548449