Array Formula

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?

Not sure what you are trying to do, but is this what you want

Formula:

Please Login or Register  to view this content.

This is very close. The only problem: This formula is returning 1-30 in the first column. I want the number in the first column to be whatever the number is next to that entry on the "Raffle Entries" sheet.

Additionally, I would like to do the same thing with another formula for other columns as well. Can you point out in this formula what I would need to change in this formula to apply it to the H column, the I column, etc? I am somewhat experienced with formulas, but am having trouble understanding this one.

Ok, how about

Formula:

Please Login or Register  to view this content.

To use col H (or I) instead of G, just change the range to B13:H5000

That works perfectly. Thank you so much!

Glad to help & thanks for the feedback.