Macro help?

P

pauldaddyadams

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Simple Formula? 8
Unique counting 18
Programmed Autofilter Query 0
football formula Fixture table help 2
search/lookup formula help. 3
Unique draws "Football" 6
formula question 4
Leauge Table....Help!!! 16

Top