79533944

Date: 2025-03-25 14:16:47
Score: 1.5
Natty:
Report link

Counting unique clients per date/time:
B9: =UNIQUE(Table1[Appt Details])
A9: =COUNT(UNIQUE(FILTER(Table1[Client Number],Table1[Appt Details]=C10)))

Counting unique clients per date:
B13: =UNIQUE(INT(Table1[Appt Details]))
A13: =COUNT(UNIQUE(FILTER(Table1[Client Number],INT(Table1[Appt Details])=C14)))

Assuming that Table1 is A1:B7, with header in first column.

enter image description here

Reasons:
  • No code block (0.5):
  • Low reputation (1):
Posted by: Vlado Bošnjaković