Can I Sort with RANDBETWEEN?

[iRaskalz]

Hello all and thank you for allowing me onto the Mr.Excel message boards,

I just have one quick question for you guys and I'm sure it's trivial...

Let me explain my situation.

My information systems 102 prof, (St. Francis Xavier University, Eastern Canada) post-midterm, realized that some of the questions n the midterm were on information on Excel we had yet to cover - he's a nice guy, so he's taking the questions off but he wants us to find out how to do it ourselves using the Internet.

The question is as follows:
"How do I sort a list when using the RANDBETWEEN function?"

Normally we would just, of course, "sort" these things but the randomize function re-randomizes the numbers every time and therefore can't be sorted.

I've been searching the web but simply cannot seem to find a way to do this! Thanks in advance.

Respectfully,

iRaskalz
Bachelor of Business Administration (1st Year)
St. Francis Xavier University
New member of Mr.Excel.com!

 

[jproffer]

You would have to copy > pastespecial.values and then sort if you wanted the numbers to stay the same. Of course, then you're not using the RANDBETWEEN function

 

[vlady]

I agree,
i think this is a test of logical approach to the students.
sorting the randbetween with out copying to other can only be attained by:

First generate the rand...
second turn off the auto calculation ( make it manual ).
third sort the rand....
this will sort it with the rand... finish...you've done the prof. query.

NOTE:

BUT IF YOU WILL ENABLE AGAIN THE AUTOCAL.

of course it will generate another rand. numbers.

 

[iRaskalz]

I agree,
i think this is a test of logical approach to the students.
sorting the randbetween with out copying to other can only be attained by:

First generate the rand...
second turn off the auto calculation ( make it manual ).
third sort the rand....
this will sort it with the rand... finish...you've done the prof. query.

NOTE:

BUT IF YOU WILL ENABLE AGAIN THE AUTOCAL.

of course it will generate another rand. numbers.

So, THANK YOU GUYS...

But, in overview, there is no way for me to RANDBETWEEN and SORT the numbers in the randomly generated list?

The only way to do it is to paste the list as values only and then sort them?

Thank you.

Best Regards,

iRaskalz