Newbie basic help

  • Thread starter Thread starter ady
  • Start date Start date
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
 
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)
 
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
 
Back
Top