Random sort/shuffle in Excel

[Guest]

I'd like to find or create a macro that will shuffle or randomize a range of
text, i.e., how you might create bingo cards. I've seen similar posts with
suggested macros and have tried them but they don't seem to work. I am using
Excel 2003.

 

[Jim Cone]

What does "they don't seem to work" mean?
How are you trying to get them (it) to work?
What is the code for one that should but doesn't work?

You may not need a macro.
If your text is in a single column, then enter "=Rand()" in an empty adjoining
column and fill down. Sort using the rand column as the key.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"WizGirl" <[email protected]>
wrote in message
I'd like to find or create a macro that will shuffle or randomize a range of
text, i.e., how you might create bingo cards. I've seen similar posts with
suggested macros and have tried them but they don't seem to work. I am using
Excel 2003.