randomizing

D

Dawn Crosier, Word MVP

Copy and paste them into Excel and then in the next column over use the Rand
Function to generate a number. Then sort on that column. This will not be
100% random, however it should be 99.9% random. The true Excel guru's know
that the Random function is flawed, but for what you want to do, it should
be sufficient.

--
Dawn Crosier
Microsoft MVP
"Education Lasts a Lifetime"

This message was posted to a newsgroup, Please post replies and questions
to the group so that others can learn as well.
Is there a way to randomize a list of 100 text (alpha) items?
 
Top