Hi Team,
how can i avoid duplicate entries when Iโm using INDEX()?
ex:" INDEX(numbers[num],RANDBETWEEN(1,5))"
thks
Your example in no way supports you question. Please clarify what you want to do.
Hi Steve,
I attached APP: โhttps://www.appsheet.com/start/c9ff372b-29f1-4302-9990-d8bb482c686bโ
I have 5 players and five numbers and every time that Iโm starting the app I want to assign a diferent number to each player (no duplicates).
thks
I donโt have access to your app, so i canโt look at it.
Please post a screenshot of the column list for the numbers table.
Hi Steve,
i attached 2 images.
itโs enough for you?
thks
Try:
INDEX(
(numbers[num] - players[num]),
RANDBETWEEN(1, COUNT(numbers[num] - players[num]))
)
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |