tourless
Board Regular
- Joined
- Feb 8, 2007
- Messages
- 144
- Office Version
- 365
- Platform
- Windows
Hi Folks.
I have column B with names, I have column E with department numbers. I need a way to count unique names grouped by department. I can figure out the counting unique values but can't work out the 'by department' part.
I have column B with names, I have column E with department numbers. I need a way to count unique names grouped by department. I can figure out the counting unique values but can't work out the 'by department' part.
John | 01 | |
John | 01 | |
John | 01 | |
Mary | 01 | |
Mary | 01 | Dept 1: 2 names |
Jim | 02 | |
Jim | 02 | |
Jim | 02 | |
Bob | 02 | |
Bob | 02 | |
Kevin | 02 | |
Kevin | 02 | Dept 2: 3names |