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. |
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