warn me when text appears

S

steve

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
 
J

John Mansfield

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)
 
B

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)
 
Top