great. thanks for that.
the 'choose' formula worked a treat.
Smeeg
--
Smeeg
------------------------------------------------------------------------
Smeeg's Profile:
http://www.excelforum.com/member.php...o&userid=29099
View this thread:
http://www.excelforum.com/showthread...hreadid=488673