Forum Discussion
Count the number of clients in a column
I'm sure there is an easy calculation to this question but for the life of me I can't figure it out.
I am trying to figure out how many clients are coming to an event. All I need is a code to count each client. I know that I can do this under the Data/Subtotal function, but I just need a total of companies coming.
| Admissions | |
| WLT Code | Clients |
| AMER | ClaimChoice Administrators |
| AMER | ClaimChoice Administrators |
| AMER | ClaimChoice Administrators |
| PRCA | Preferred Care |
| PRCA | Preferred Care |
| IMCS | Redbridge |
| IMCS | Redbridge |
| PIMA | Pima County |
| PIMA | Pima County |
| # Clients | |
| 5 |
4 Replies
ShelleyVan7990 Since you tag you post with Office365, you should have UNIQUE functions, like this:
= COUNT(UNIQUE(clients))
where "clients" refers to the column/range where the client names are listed.
That would be 4 in your example, not 5
- It is coming up 0 not 4
ShelleyVanEtten Oooops. Yes, I forgot the "A" after COUNT, Sorry,
