Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |