putting random numbers in order

I would like to generate random numbers between two values, then have the list ordered from smallest to largest. I need 20 random numbers between two values that are kept on the same sheet. I am not worried about duplicates, however I need the random list to be ordered from smallest to largest.

More details:
in cell A2 I have the lower bound
in cell A3 I have the upper bound
I would like the results to display in column C

So, if I had
A2=1
A3=43
I have currently used RANDBETWEEN($A$2,$A$3) for the 20 entries in column C, however the listing isn't ordered/sorted from largest to smallest.

I know I can copy the column and paste it as values to another column, then sort the list, however I was wondering if I could get these 20 random values ordered automatically.

I am using Excel 2007.

You will need to use a helper column. If you have your initial results in C1:C20, in D1 put:

Please Login or Register  to view this content.

Then copy down to D20.