warn me when text appears

[Guest]

im trying to find out if excel will warn me if text appears in a range of
cells more than twice,, i run a fantacy league but each member can only have
two players from the same team ie leeds,mancester, liverpool. can i write a
formula that will tell me if one team appears more than twice

 

[Guest]

Steve,

As an example, assuming your data is the range A1:A10, this formula will
return TRUE for any duplicates:

=IF(COUNTIF($A$1:$A$10, A1)>1,TRUE,FALSE)

 

[Peo Sjoblom]

You might want to apply this if these entries are typed

http://www.cpearson.com/excel/NoDupEntry.htm

 

[Bob Phillips]

You could use the formula

COUNTIF($A$1:$A$10, A1)>1

with conditional formatting

--

HTH

RP
(remove nothere from the email address if mailing direct)