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