Thanks Daddy and Bob

I tried those solutions too and all three work!

Gosh i went from not being able to work out a formula to being spoilt
for choice!!!

in the end i went with Mikeopolo my simple mind could just about
conprehend this one!!!!

thanks alot

James


--
superkopite
------------------------------------------------------------------------
superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496
View this thread: http://www.excelforum.com/showthread...hreadid=503604