My Data looks like
Clients ID Fee Branch
A0001 125 SW
A0001 100 SW
A0002 200 NW
A0003 300 SW
A0004 555 NW
A0001 567 SW
A0002 456 NW
A0005 246 SW
A0005 876 SW
A0007 345 NW
I am looking for a formula that can be count unique clients in each of the branches.
Bookmarks