ExcelBanter - Random Sort

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Random Sort (https://www.excelbanter.com/excel-programming/317319-random-sort.html)

Mark Scholes

Random Sort

Hi,
I have a list of prices (26,280) which I want to have in a
random order for a simulator of revenue.

Thanks MarkS

Chip Pearson

Random Sort

Mark,

In a blank column next to your data, enter =RAND() and copy down
as far as you need to go. Then, sort by this column.

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

"Mark Scholes" wrote in message
...
Hi,
I have a list of prices (26,280) which I want to have in a
random order for a simulator of revenue.

Thanks MarkS

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