Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i get an error message if identical data is in two or more.
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i get an error message if identical data is in two or more.
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data error message | Excel Discussion (Misc queries) | |||
Data validation error message | Excel Discussion (Misc queries) | |||
Data Validation Error Message | Excel Discussion (Misc queries) | |||
Data Validation error message | Excel Worksheet Functions | |||
external data error message | Excel Discussion (Misc queries) |