Advice needed...

  • Thread starter Thread starter Duncan
  • Start date Start date
D

Duncan

I need to sort 4 random numbers into numerical order. the numbers would be
entered into a row for example, A1:A4.

Now, I need to be able to check each of the numbers and place them in
numerical order, highest first, in A10:A13.... is this possible. I can take
the highest and lowest by way of the max and min function but my head is
caved in trying to think of how to sort the 2 middle ones out. Any help on
this would really be appreciated..... Thanks in advance!!

Duncan
 
Try

=LARGE(A1:A4,1)
=LARGE(A1:A4,2)
etc.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
In A10 put

=LARGE($A$1:$A$4,ROW(1:1))


copy down to A13

Regards,

Peo Sjoblom
 
what can I say..... it all looks so easy now :o)) time for a coffee.
Thanks!!!
 
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

advice needed 2
Showing the top result from a range of cells 6
Numerating Cells. 2
Sorting within Rows 7
In col if high is 83 and low 15 how do i get high =100 and low=0 2
Excel finding top of range 1
sorting column of numbers 1
Formatting cells 2

Back
Top