Forum Discussion
Looking for automated way to build an event attendance list
I need to create attendance lists for events where several hundred tickets are sold. Some people buy a single ticket while others buy multiple tickets. Is there a formula I can use so that (in this...
Randy340 you could use a pivot table or power query to do this or using modern formulas you can use:
=LET(
in, A2:D9,
names, UNIQUE(TAKE(in, , 2)),
seats, BYROW(
names,
LAMBDA(r,
LET(
tix, FILTER(in, MMULT(--(TAKE(in, , 2) = r), {1; 1}), ""),
SUM(tix) & ", " & TEXTJOIN(" ", , TAKE(tix, , -1))
)
)
),
HSTACK(names, TEXTBEFORE(seats, ","), TEXTAFTER(seats, ", "))
)