warn me when text appears
 

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
--
steve b

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)

----
Regards,
John Mansfield
http://www.pdbook.com

"steve" wrote:

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
--
steve b

You might want to apply this if these entries are typed

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

--
Regards,

Peo Sjoblom


"steve" wrote in message
...
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
--
steve b

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)


"John Mansfield" wrote in message
...
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)

----
Regards,
John Mansfield
http://www.pdbook.com

"steve" wrote:

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
--
steve b