Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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" 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How Excel 2003 Highlight random cells and running tally appear? | Excel Discussion (Misc queries) | |||
Excel 5 and Excel 2000 question. | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Generating Correlated Random Values in Excel | Excel Discussion (Misc queries) |