How do you randomly sort a RANGE

B

Bernd Plumhoff

Hello,

I suggest to take my function UniqRandInt() from www.sulprobil.com.

Then you can select cells A1:E5, array-enter
=UniqRandInt(99)
with CTRL+SHIFT+ENTER, for example, and the 25 cells A1:E5 will be filled
with unique (=non-repeating) random integers between 1 and 99.

HTH,
Bernd
 
L

latturne

Thank you so much for your help, however...I think I should have mentioned
I'm using words in the spaces instead of numbers. Is it still possible to
randomly sort this type of range?
 
M

Myrna Larson

Use the random integers that the function returns with the INDEX function to
get the text, i.e. using Bernd's example, and your list in F1:F100,
=INDEX(F1:F100,A1)
 
J

joeu2004

latturne said:
Thank you so much for your help, however...I think I should
have mentioned I'm using words in the spaces instead of numbers
Is it still possible to randomly sort this type of range?
Click to expand...

I did not see your original posting, but the following
standard procedure might solve your problem. Suppose
your text is in Column A. In parallel cells in Column
B, enter the formula =RAND(). Now select the cells in
Columns A and B and sort based on Column B by going to
Data -> Sort and selecting Sort By Column B.

Note: The act of sorting will cause RAND() to be
re-evaluated. Consequenty, the values in Column B will
not appear to be in sorted order. Nonetheless, Column
A will be sorted randomly. If the new values in Column
B bother you, you could Copy and Paste Special Value
Column B into Column C, then sort Columns A, B and C
with Sort By Column C. You could even delete Column B
first, if you like.
 
Top