Forum Discussion

MontyKnoll's avatar
MontyKnoll
Copper Contributor
May 16, 2023

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...
BI & Data Analysis
excel
Formulas and Functions
office 365
Lorenzo's avatar
Lorenzo
Silver Contributor
May 16, 2023

Hi MontyKnoll 

 

If you run 365 one way:

=LET(
  UniqBySession, CHOOSECOLS(UNIQUE(Table1),3),
  Subjects, SORT(UNIQUE(UniqBySession)),
  CountBy,  LAMBDA(session, ROWS(FILTER(UniqBySession,UniqBySession=session))),
  VSTACK(
    {"Session","# Unique Client"},
    HSTACK(Subjects, MAP(Subjects,CountBy))
  )
)

 

 

Resources