I want to count the unique values in my data, but based on a specific criteria.
I have set up my data as above, and I want to get the unique count of Date and Handyman, but I would like to do it based on the value in the Month column. I know I can manually select the relevant rows for each month, but ideally if I can set up a formula that takes into consideration the Month column that would be ideal.
The formula I have used to get the distinct count of Date and Handyman is =COUNT(DISTINCT({Date and Handyman}))