View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default how do i get an error message if identical data is in two or more.

Do you want to trap it on input (some event error) or just flag the
duplicates (say in colour)?

--

HTH

RP

"bobone" wrote in message
...
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