ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formatting cells (https://www.excelbanter.com/excel-discussion-misc-queries/153899-formatting-cells.html)

Big Bubba

Formatting cells
 
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

Jim Rech

Formatting cells
 
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




Dallman Ross

Formatting cells
 
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


All times are GMT +1. The time now is 10:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com