Cheers for this Ron.

I forgot the CTRL-SHIFT-ENTER to enter the array formula, DOH!!

I think it does the job, couple that with warning messages in data validation and i don't think they can go too far wrong!!

Many Thanks for your help