The formula that I gave you will still work then. Simply change "Did Not
Go" to "No Show" in the formula and you will be OK.


Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=466772