MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Eliminate a choice from random numbers


Posted by Bruce Herman on January 20, 2002 7:02 AM

I'm doing a math problem involving a spinner where the spinner lands on a counting number from 1 to 10. The spinner is spun twice, but the second spin must be a different number from the first spin. The formulas I have tried involve just spinning again, but that sometimes results again in the same number.


Posted by Tom Dickinson on January 20, 2002 10:04 AM

Allow 2nd spin of 1 to 9, if result => first number, add 1 (NT)