Hi,

I have a problem which I need someone to look at. I have a list of 1
teams and I need a formula to check the data and for it to identify a
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 man
arsenal entries as only two are allowed

Can anyone help?

Regards

Pau

--
pauldaddyadam
-----------------------------------------------------------------------
pauldaddyadams's Profile: http://www.excelforum.com/member.php...fo&userid=2249
View this thread: http://www.excelforum.com/showthread.php?threadid=39461