ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How can I randomize digits in Excell? (https://www.excelbanter.com/excel-worksheet-functions/86531-how-can-i-randomize-digits-excell.html)

An

How can I randomize digits in Excell?
 
For example: I have a row of 6 digits, number 1 to 6, which I want to
randomize over 30 trials... how can i do this?
I'm working with micr. excell 2003.

Ardus Petus

How can I randomize digits in Excell?
 
Try this (to be copied in a 30x6 range):
=INDEX($A$1:$F$1,1,INT(RAND()*6)+1)

HTH
--
AP

"An" a écrit dans le message de news:
...
For example: I have a row of 6 digits, number 1 to 6, which I want to
randomize over 30 trials... how can i do this?
I'm working with micr. excell 2003.





All times are GMT +1. The time now is 03:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com