In a column next to your list of cities, enter the formula
=RAND() and fill down as far as your list goes. Then, sort your
data using the random numbers as the sort key.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Tam" wrote in message
...
How do I sort a list of cities in US by randomize in MS Excel
or Access?
Thanks
Tam