Is there a way for me to get a unique count of data text? I have the
following table format -

Count of User Group
User CS DES ECS EDM Grand Total
Abb, Michael 2 2 2
Abl, Denise 3 3

How do I get a unique count of user by group, in other words, my first
example should be 1 under EDM for Michael.
Thanks