unique Counting

[iksotof]

Hello,

I have a table of clients who have a particular service, some clients have multiple services, I need totals for clients who are on one service and totals for those on multiple. I have attached an example, any suggestions would be greatly welcomed.


Thank you in advance
Darren.

[HansV]

See the attached version. I used a helper column that returns the number of unique services per client.

eg.xlsx

[iksotof]

Thank you Hans

that's fabulous.