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