Hi Biff,

Sorry for the vague desc in the first post

Thanks, it works now but i noticed that the formula is quite static,
does not support if the data increases unless i manually change it. How
to make dynamic?

Thanks.


--
mayanair
------------------------------------------------------------------------
mayanair's Profile: http://www.excelforum.com/member.php...o&userid=33847
View this thread: http://www.excelforum.com/showthread...hreadid=536267