Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can i get excel to warn me if text appears in 3 different cells | Excel Worksheet Functions | |||
Formula appears as text | Excel Worksheet Functions | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Wrapped text appears as xxxxxx | Excel Discussion (Misc queries) |