Hi
see:
http://www.cpearson.com/excel/NoDupEntry.htm

--
Regards
Frank Kabel
Frankfurt, Germany


bobone wrote:
i am writing a task rota with many personnell in it
i.e. sweeping -- jones
cooking ----- thomas
washing ---- edwards
how can I make sure that the peoples names dont appear twice,
I will be grateful for any suggestions