Newbie basic help

A

ady

Hi all,
I'm very new to this and trying to work out a formula to put numbers i
order, sounds simple but i just cant work it out!

I just need to be able to take a selection of rows with random number
and display them in numerical order somewhere else.

I've found the MAX and MIN commands to get the highest and lower bu
not got a clue about how to do the rest.

Any help would be very much appreciated.
Thanks
Ad
 
B

Bob Phillips

Assuming that the numbers are not generated by the RAND function, why not
just sort them (Data>Sort).

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
F

Frank Kabel

Hi
if your target range starts in row 1 try this for descending
=LARGE(A1:A100,ROW())
or for ascending order
=SMALL(A1:A100,ROW())
copy down
 
Top