Create a list of tickets in excel based on a number value in a specific column. My Ticket numbers are in B13:B5000. Name is C13:C5000. Phone number is D13:D5000. Number of tickets is in G13:G5000. Here is my formula I am pasting into another sheet:
=LET(
tk, FILTER('Raffle Entries'!B13:B5000, (ISNUMBER('Raffle Entries'!G13:G5000)) * ('Raffle Entries'!G13:G5000 > 0)),
nm, FILTER('Raffle Entries'!C13:C5000, (ISNUMBER('Raffle Entries'!G13:G5000)) * ('Raffle Entries'!G13:G5000 > 0)),
ph, FILTER('Raffle Entries'!D13:D5000, (ISNUMBER('Raffle Entries'!G13:G5000)) * ('Raffle Entries'!G13:G5000 > 0)),
qt, FILTER('Raffle Entries'!G13:G5000, (ISNUMBER('Raffle Entries'!G13:G5000)) * ('Raffle Entries'!G13:G5000 > 0)),
combineRows, LAMBDA(a, i,
LET(
t, INDEX(tk, i),
n, INDEX(nm, i),
p, INDEX(ph, i),
q, INDEX(qt, i),
repeated, HSTACK(
SEQUENCE(q,,t),
SEQUENCE(q,,n),
SEQUENCE(q,,p)
),
VSTACK(a, repeated)
)
),
REDUCE({"Ticket #","Name","Phone"}, SEQUENCE(ROWS(tk)), combineRows)
)
This is returning a #VALUE error.
WHY?
Bookmarks