Formatting cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Big Bubba said:
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?
Click to expand...

Sounds like maybe you want the RANK function?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting 3
Showing the top result from a range of cells 6
Excel finding top of range 1
Reversing the order of data separated by commas within a cell? 5
highest second highest and third highest 6
How do I find the second highest value. 3
Inserting Symbols with IF Function. 4
Highlight highest / lowest number in a row 3

Back
Top