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)

"In need of help!" <In need of wrote in
message ...
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.