I need to count unique/distinct employee names in a list based on the area that they work. There is variable work areas and variable occurances of employees.
ie,
BH Jones
BH Jones
BH Smith
BH Smith
BH Smith
SP Gray
SP Gray
SP Brown
So I would get
BH = 2
SP = 2
Total = 4
Bookmarks