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