ExcelBanter - how do i get an error message if identical data is in two or more.

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - how do i get an error message if identical data is in two or more. (https://www.excelbanter.com/excel-programming/309044-how-do-i-get-error-message-if-identical-data-two-more.html)

bobone

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

Frank Kabel

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

Bob Phillips[_6_]

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

All times are GMT +1. The time now is 05:49 AM.