I'm using Weebly to manage an online raffle for a non-profit. Unfortunately the reporting from the store is "challenged".
We allow "tickets" to be purchased in 1-3-5-10 quantities and I've done a simple-simple filtering and formula to determine the real quantity for an order. Red cells (K:Q below) are the calculated values.
My problem is how to expand such that an order for 10 tickets expands to 10 entries and the same for 3-5, ... Ideally then use a random function to pick from 1 to n from that expanded list of order numbers. Example below would have 20 individual entries for order 519220193, 10 for 139036459, etc.
Winning order number than can be looked up (vlookup?) on my master sheet where I keep all order details (name, phone, ...).
My sheet looks like this:
I've got 48 items to do, so planning to filter on SKU (1-48) and repeat...
Tried searching forum but guessing not using the right keywords to find a solution.
Thank you!
Martin
We allow "tickets" to be purchased in 1-3-5-10 quantities and I've done a simple-simple filtering and formula to determine the real quantity for an order. Red cells (K:Q below) are the calculated values.
My problem is how to expand such that an order for 10 tickets expands to 10 entries and the same for 3-5, ... Ideally then use a random function to pick from 1 to n from that expanded list of order numbers. Example below would have 20 individual entries for order 519220193, 10 for 139036459, etc.
Winning order number than can be looked up (vlookup?) on my master sheet where I keep all order details (name, phone, ...).
My sheet looks like this:
I've got 48 items to do, so planning to filter on SKU (1-48) and repeat...
Tried searching forum but guessing not using the right keywords to find a solution.
Thank you!
Martin