Alert Message

[Guest]

Hi,
I need to create a document whereby text team name entries are limited and a
message will appear to notify me. So for example, if the team Liverpool FC
apprears twice and the third time the entry is input a message will flag up
that it is the third entry.

Can you help?

Many Thanks.

 

[Bob Phillips]

You can get a message on a duplicate if you use Data Validation, with an
allow type of custom, and a formula of

=COUNTIF($A$1:A1,A1)=1

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)