How can I randomize digits in Excell?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Try this (to be copied in a 30x6 range):
=INDEX($A$1:$F$1,1,INT(RAND()*6)+1)

HTH
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

eliminate negative value from normal random number distribution 4
How do I calculate age using a 12 digit social security number in MS Excel? 0
HOW DO I CONVERT A NUMBER'S MOST SIGNIFICANT DIGIT TO A SINGLE DI. 4
Help Please! Random generator issue. 2
Random Numbers 2
RANDOM # around a MEAN with STANDARD DEVIATION 16
using the =page! feature to transpose a row to column 0
Adding a zero to the front of numbers 5

Back
Top