How do you randomly sort a RANGE
 

I need help with randomly sorting BINGO squares so no one card is alike.

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

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?

"Bernd Plumhoff" wrote:

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

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)


On Thu, 29 Sep 2005 06:18:08 -0700, "latturne"
wrote:

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?

"Bernd Plumhoff" wrote:

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

"latturne" wrote:
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?

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.