How to generate random non-repeating values?

A

A

awox2021-07-05 15:10:04

excel

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

How to generate random non-repeating values?

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

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

J

joker_4fun2019-09-02 11:15:01

Python. How to rename a file based on its size? 1Reply

T

Talyan2019-09-07 23:52:59

How to make such a macro in Excel? 1Reply

P

phpus2015-04-10 21:01:41

Merging MS Excel and MS Word data, how? 1Reply

D

Denis _______________2017-04-09 20:18:55

How to sort a text table according to a pattern? 1Reply

A

Artem Matyashov2017-04-12 18:31:50

How to write this formula in excel? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question