Thanks for many replies guys... i appreciate your help...

I find mr teacher's way is the best solution for me.. easy and quick
formula.. many thanks for the quick replies..

this problem been with me for so long till out of somewhere i found
this forum and i thought why not ask experts to solve my problems..
indeed it worked.. many thanks to you guys.. did a good job for me..
thank you


--
Hero_honda
------------------------------------------------------------------------
Hero_honda's Profile: http://www.excelforum.com/member.php...o&userid=34713
View this thread: http://www.excelforum.com/showthread...hreadid=544797