Hello Paul, i've alreay got the the expected output. Thanks too much

While your formula is simple but effective but i tried many complex
functions with Count, If, And but ineffective at all.

Thanks again


--
kevink79
------------------------------------------------------------------------
kevink79's Profile: http://www.excelforum.com/member.php...o&userid=28200
View this thread: http://www.excelforum.com/showthread...hreadid=477425