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
 
Hi Duncan
In A1, type =LARGE(A10:A13,1)
Do the same in A2,A3,A4, making sure you change the last number in the
formula to 2,3 and 4

HTH
Michael
 
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... 3
Trying to find additional ranges outside of min, max, and average 2
Using IF and MAX functions together 4
Choose best values in a list 1
Highest alphanumeric 6
avoid Descending Sort putting error cells uppermost in collumn 3
MIN will not find lowest of calculated values How? 5
Function for 2nd and third low or Max 2

Back
Top