I have two columns with data; name and entry number. Something like
I am using =RANDBETWEEN(1,9) to pick an entry number and have a formula to show the name attached to it.
Bob wins the 1st prize. Is there a formula that would then eliminate the possibility of Bob winning the 2nd prize?
My real sheet is a little more complex, but I believe this gets the point across. Thanks!
| Name | Entry Number |
| Bob | 1 |
| Bob | 2 |
| Bob | 3 |
| Fred | 4 |
| Fred | 5 |
| Sue | 6 |
| Sue | 7 |
| Rich | 8 |
| Rich | 9 |
I am using =RANDBETWEEN(1,9) to pick an entry number and have a formula to show the name attached to it.
Bob wins the 1st prize. Is there a formula that would then eliminate the possibility of Bob winning the 2nd prize?
My real sheet is a little more complex, but I believe this gets the point across. Thanks!
