Hi Peter - my apologies. Your second formula was spot on.

I would like to thank you for taking the time to help me. Your input is
very appreciated.

The best aspect of these formulas is that it removes the element of
human error!

Thanks you.

Shaun in Sydney


--
shaunl
------------------------------------------------------------------------
shaunl's Profile: http://www.excelforum.com/member.php...o&userid=25140
View this thread: http://www.excelforum.com/showthread...hreadid=527886