Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
Profil pysy_mik
 | Femeie
25 ani
Teleorman
cauta Barbat
25 - 44 ani |
|
Mrrrr
AdMiN
 Inregistrat: acum 18 ani
Postari: 2308
|
|
key words: random array RANDARRAY excel 2024 excel 365
I have a few names for an example Excel file I am generating for a colleague, and would like to create some data table, and the 4-5 names to be randomly arranged in a 40-50 names array without having to write them down manually.
I have the following list of names in K5:K10:
Andrei
Bogdan
Claudiu
Daniel
Emil
Florin
Formula in L5 randomizes the names onto 24 rows:
=INDEX($K$5:$K$10; RANDARRAY(24;1;1;6; TRUE))
Similarly, to create an array of random numbers, you can use RANDARRAY as well:
=RANDARRAY(24;1;50;93; TRUE))
You can also generate random dates:
=RANDARRAY(24; 1; TODAY()-30; TODAY()+30; TRUE)
The syntax of RANDARRAY is:
RANDARRAY([rows] ; [columns] ; [min] ; [max] ; [integer]
Source: ChatGPT
_______________________________________
|
|
| pus acum 3 saptamani |
|