Forum Discussion
Formula for unique values under a certain criteria.
Hi everyone! I'm trying to workout a formula that counts how many unique people attend an appointment (If 1 person attends the appointment 2 times then it still only counts them as 1). But also I...
An alternative could be Power Query. In the attached file you can add data to the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.