Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |