Reverse Raffle setup: using Randbetween without duplicates

Hello all,

I am trying to use Excel to run a reverse raffle at a rotary club function. I have a graph set up where I can color-fill in numbers that I have already pulled. I have NO problem doing this manually.

My issue is: I am trying to set up a randbetween formula that will exclude any numbers already drawn. Say the criteria set is 1:200. I have the numbers listed in column Q away from the table. The big issue is: I do not want to calculate all numbers instantly, rather, use F9 to draw a new random number each time it is pressed, without duplicating. Is there a way to use the randbetween formula or any formula that will not duplicate numbers I enter into a column? Say Column R, since it is right next to the list in column Q.

Thank you in advance for any insight on this.

Matt

Thank you, I will give this a try.

Matt

This is so close. I changed the fill to include cells Q1:200 in order to incorporate all 200 tickets. However, I am running into a problem as I need one of the cells (any one in particular, I picked Q1) to display a random number with no repeats. This formula will give me an independent order each time, but may start out with the same number in a given cell (Q1). I'm not sure if this is possible in Excel.

Thank you for your insight.
Matt

Thanks, I will try this as well.