Duplicate entries using INDEX()

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.


image

Hi Steve,
i attached 2 images.
it’s enough for you?
thks

1 Like

Try:

INDEX(
  (numbers[num] - players[num]),
  RANDBETWEEN(1, COUNT(numbers[num] - players[num]))
)