Random Sort

  • Thread starter Thread starter Mark Scholes
  • Start date Start date
M

Mark Scholes

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

random number generation help 3
random number generator for scientific simulation purposes 1
Random Range of Dates 2
how do I create a random list whilst keeping some entries fromrandomizing? 1
Windows 10 Activate windows now message 3
Windows 10 One of my previous builds is experiencing random, multiple BSODs 9
Selecting from a randomized list 7
Random selection of records based on specifc value 5

Back
Top