Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Order of Numbers
I am looking to be able to put values in the order of 1 to 5 in a range of
cells based on the order of values in another range - as an example the values in range (row) one may be 12,36,25,40,19 which would result in this being shown in the 'order' range as 5,2,3,1,4. Hope this makes sense |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Order of Numbers
Hi,
Let's assume these numbers are in A1 to E1. Put this in A2 and drag right =RANK(A1,$A$1:$E$1) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Kerry" wrote: I am looking to be able to put values in the order of 1 to 5 in a range of cells based on the order of values in another range - as an example the values in range (row) one may be 12,36,25,40,19 which would result in this being shown in the 'order' range as 5,2,3,1,4. Hope this makes sense |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Order of Numbers
Suppose you had those values 12, 36, 25, 40, 19 in cells A1 to E1,
then you can put this formula in A2: =RANK(A1,$A1:$E1) and copy this across to E2 to give you the numbers you require. Hope this helps. Pete On Apr 7, 9:48*am, Kerry wrote: I am looking to be able to put values in the order of 1 to 5 in a range of cells based on the order of values in another range - as an example the values in range (row) one may be 12,36,25,40,19 which would result in this being shown in the 'order' range as 5,2,3,1,4. *Hope this makes sense |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
numbers in numerical order | Excel Worksheet Functions | |||
numbers in order | Excel Discussion (Misc queries) | |||
reverse order of numbers | Excel Discussion (Misc queries) | |||
getting numbers divisible by 4 from random numbers in ascending order | Excel Worksheet Functions | |||
Transpose and order array numbers | Excel Worksheet Functions |