Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Simple Formula?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
simple interest formula in excel | Excel Discussion (Misc queries) | |||
Help - Simple Formula ! | Excel Discussion (Misc queries) | |||
Simple formula help | Excel Worksheet Functions | |||
help with simple formula | Excel Worksheet Functions | |||
Excel Miscalculates simple formula..Help!! | Excel Worksheet Functions |