GomaPile
Active Member
- Joined
- Jul 24, 2006
- Messages
- 334
- Office Version
- 365
- Platform
- Windows
Hello all,
Can someone help please. We have a school soccer team where we draw numbers out of a bag, who goes first lower to highest or odds & even etc... Found this formula that works well for our school soccer team.
What Im trying to achieve using my random personal numbers, after pressing F9 multiple times some of Cells have repeated with the same value more than once, where I would prefer 3 random unique numbers everytime.
The formula below is copied 3 times with the same info across 3 separate cells from A1), B1), C1)
=INDEX(K1:K10, RANDBETWEEN(1, COUNT(K1:K10)), 1)
My list of personal Coaches Random Numbers in Cells K1:K10 downwards, and no 2 numbers are displayed with same value, every number is unique.
We appreciate anyone's support
Kind Regards
Nasa2
Can someone help please. We have a school soccer team where we draw numbers out of a bag, who goes first lower to highest or odds & even etc... Found this formula that works well for our school soccer team.
What Im trying to achieve using my random personal numbers, after pressing F9 multiple times some of Cells have repeated with the same value more than once, where I would prefer 3 random unique numbers everytime.
The formula below is copied 3 times with the same info across 3 separate cells from A1), B1), C1)
=INDEX(K1:K10, RANDBETWEEN(1, COUNT(K1:K10)), 1)
My list of personal Coaches Random Numbers in Cells K1:K10 downwards, and no 2 numbers are displayed with same value, every number is unique.
We appreciate anyone's support
Kind Regards
Nasa2
Last edited:
