Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Of a row of numbers I would like to pick the highest to lowest in order?
Or pick the highest number, then exclude it from another search for the next highest number? -- Big Bubba |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I would like to pick
"pick" is not an Excel term so I don't know what exactly you want to do. But you might look at the LARGE worksheet function in Help. -- Jim "Big Bubba" wrote in message ... Of a row of numbers I would like to pick the highest to lowest in order? Or pick the highest number, then exclude it from another search for the next highest number? -- Big Bubba |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
In , Big Bubba
spake thusly: Of a row of numbers I would like to pick the highest to lowest in order? Or pick the highest number, then exclude it from another search for the next highest number? Sounds like maybe you want the RANK function? -- dman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
formatting cells | Excel Discussion (Misc queries) | |||
Formatting cells | Excel Discussion (Misc queries) | |||
formatting cells | Excel Worksheet Functions | |||
Conditional Formatting Multiple cells based on 2 cells | Excel Worksheet Functions | |||
Formatting cells | Excel Worksheet Functions |