Hi,

I have a problem which I need someone to look at. I have a list of 11
teams and I need a formula to check the data and for it to identify an
error message if more than two of the same teams are listed.

e.g.
Arsenal
Aston Villa
Liverpool
Chelsea
Arsenal
Wigan
West Brom
Arsenal
Arsenal
Birmingham
Liverpool

I would need a cell to highlight the error that there are two many
arsenal entries as only two are allowed

Can anyone help?

Regards

Paul


--
pauldaddyadams
------------------------------------------------------------------------
pauldaddyadams's Profile: http://www.excelforum.com/member.php...o&userid=22499
View this thread: http://www.excelforum.com/showthread...hreadid=394615