Randomized data tables

T

TammyLB

Joined
Feb 14, 2014
Messages
3
Reaction score
0
I need to produce 2 columns of random numbers between 1 and 24, but the numbers cannot be repeated in each column. I tried sorting a random column, but I keep getting decimal numbers between 0 and 1. Can anyone help? Please!!!
 
The function =rand() will produce the numbers you are receiving. If you want numbers in a specific range you can you use =randbetween(0,25) or maybe =randbetween(1,24) to get the results you are looking for. It won't give you exactly the results you want because it will repeat numbers. I hope this helps!
 
Yes, the randbetween function gives whole numbers, but the numbers repeat in the column. Is there no way to make a list of 1 - 24 and them randomly mix those numbers?
 
What you would do for that is create a list of numbers 1-24, then create a column for sorting using one of the random number formulas and resort the table on that column. It will mix up your 1-24 numbers.
 

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

MACRO RUN random percentage and copy of column values 1
Excel Repeating a RAND() function under certain conditions 0
Six columns randon no.'s no dupes 6
Modify working code to expand the output. 5
reffering another cell value which contains RAND() 0
Order numbers from smallest to largest 6
Random numbers between two values 0
PowerPoint Shuffle (swap) objects on PPT slides with the same name only 0

Back
Top