How to generate random non-repeating values?

A

awox2021-07-05 15:10:04

excel

awox, 2021-07-05 15:10:04

In 40 cells it is necessary to generate 40 values randomly (for example: = RANDBETWEEN (1; 40)) but in such a way that the values do not repeat.

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

H

hint000, 2021-07-05
@hint000

generate from 1 to 40 in order, then: https://www.google.com/search?q=excel+shuffle

Similar questions

N

Nikolai Shevtsov2015-05-27 18:07:17

I

Ivan Medvedev2020-03-04 08:06:16

N

nikmil2019-08-31 11:08:57

T

Torento203452021-03-22 18:42:31

O

other_letter2017-04-13 09:09:48

Didn't find what you were looking for?