| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Records Between A-K and L-Z
I have a spreadsheet used to track claims. Case Managers are assigned the
cases based on the surname of the client. For instance, Jane case manages all clients with a surname between A and K and Jill manages all clients with a surname between L and Z. I would like to set up a formula to count the number of cases each case manager has. Can this be done with a wildcard? I have been fighting with this trying to find the answer, which I'm sure is simple. Any assistance you can provide is greatly appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count records in a date range | Excel Discussion (Misc queries) | |||
| count duplicate records in a group | Excel Worksheet Functions | |||
| How can the count of filtered records always display? | Excel Worksheet Functions | |||
| Deleting specific records | Excel Discussion (Misc queries) | |||
| Filter Count of Records Retrieved. | Excel Discussion (Misc queries) | |||
Threaded Mode
