Duplicate entries using INDEX()

J_jvs · 06-03-2020 01:50 AM

Hi Team,
how can i avoid duplicate entries when I’m using INDEX()?
ex:" INDEX(numbers[num],RANDBETWEEN(1,5))"

thks

Steve

Your example in no way supports you question. Please clarify what you want to do.

J_jvs

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

Steve

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.

J_jvs

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

Steve

Try:

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