| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting rows without changing order of my values!
How can i sort a row of values, however without changing the order of my
values. I just want the values of 1-20 to be placed next to my text (in a seperate row) according to which is the highest etc... such as for example: My values: 20 - 40 - 10 - 30 Sorted sequence: 2 - 4 - 1 - 3 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sorting rows without changing order of my values!
Take a look at =rank() in excel's help.
roger wrote: How can i sort a row of values, however without changing the order of my values. I just want the values of 1-20 to be placed next to my text (in a seperate row) according to which is the highest etc... such as for example: My values: 20 - 40 - 10 - 30 Sorted sequence: 2 - 4 - 1 - 3 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looking up multiple items and suming the values on their rows | Excel Discussion (Misc queries) | |||
| Strange behaviour when sorting rows | Excel Discussion (Misc queries) | |||
| sorting a constantly changing set of rows in VBA | Excel Discussion (Misc queries) | |||
| How to randomely distribute non-numerical values across rows? | Excel Worksheet Functions | |||
| Graph values in ascending order | Excel Discussion (Misc queries) | |||
Linear Mode
