ExcelBanter - How do I sort a list of cities in US by randomize in MS Excel or .

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I sort a list of cities in US by randomize in MS Excel or . (https://www.excelbanter.com/excel-discussion-misc-queries/21828-how-do-i-sort-list-cities-us-randomize-ms-excel.html)

Tam

How do I sort a list of cities in US by randomize in MS Excel or .

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

Chip Pearson

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

All times are GMT +1. The time now is 03:18 PM.