Way behind on the reply for this but thanks for that @Chloe .
I use those all the time but when you have 50 different things going its better to have the following script work so logic can be in place that doesn’t require to cover ever single instance of what might happen.
Lets say you want a random number picked and that would be between 1 -100
I would like it to say if the number equals 12 then do this, unless 12 was already shown Then do this.
I could not get it to pick a new number if the number was already shown thats why I thought If,Then, Else would be great to have in the program.
HI @eplotkin,
I know it’s been a while, but I just happened to come across this post. Maybe you’ve found your answer by now, but a work-around had popped into my head.
When someone selects a number, add it to a cell in excel. When someone picks another number, first filter the excel spreadsheet by the number they select. If the number of records is 0 after filtering, you know that number has not been picked yet. If the number is anything other than 0, you know that it has been picked.