Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How can I create a variable which contains the values 1 through n, in a random order without repetition?

April 26, 2017create repetition values

0

Posted

How can I create a variable which contains the values 1 through n, in a random order without repetition?

1 Answer

0

Posted

First, create a variable with random numbers between 0 and 1. You can do this with the spreadsheet formula =rnd(1). Then rank those numbers using the Rank option with sequential Ranks for Ties (this option will ensure that there is no repetition), available from the Vars toolbar button.