Is there a way to take the winner out of the table so it doesn't get drawn again? or if I need to add new contestants into the drawing. I just add to the bottom?
Hi Tracie. That's a great question. I would add two additional columns to the database to identify previous winners. Let's say you have a column called "previous winners", and in that column you have 1s and 0s. For IDs that have previously been drawn as winners, you put in a "1", and for IDs that have not won previously, you put in a "0." I would then write a formula to get a list of IDs that exclude previous winners. Let's called this column "non-winner IDs". We would use IF([previous winners]=1,"",[previous winners]) to generate a list of IDs that exclude the previous winners. In your RANDBETWEEN function, you can replace the original ID column with the "non-winner IDs" column. That's the quickest solution I can think of. I hope this helps! Thank you.
Is there a way to take the winner out of the table so it doesn't get drawn again? or if I need to add new contestants into the drawing. I just add to the bottom?
Hi Tracie. That's a great question. I would add two additional columns to the database to identify previous winners. Let's say you have a column called "previous winners", and in that column you have 1s and 0s. For IDs that have previously been drawn as winners, you put in a "1", and for IDs that have not won previously, you put in a "0." I would then write a formula to get a list of IDs that exclude previous winners. Let's called this column "non-winner IDs".
We would use IF([previous winners]=1,"",[previous winners]) to generate a list of IDs that exclude the previous winners.
In your RANDBETWEEN function, you can replace the original ID column with the "non-winner IDs" column.
That's the quickest solution I can think of. I hope this helps! Thank you.