Excel finding top of range

N

NassauLIMan

I have a column of numbers. Instead of sorting and manually ID's the highest
and lowest value what is the function in Excel that I can use to have it look
at the column of numbers and tell me the highest and lowest value?

I am sure it is a simple function but for the life of me I can not find it
in the help for the program
 

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

Showing the top result from a range of cells 6
=average - eliminate the top and bottom number 5
finding is a value is betwen a range of values 5
sorting column of numbers 1
Changing fill colour of cells in a range 8
Interesting situation help required!! 3
Reversing the order of data separated by commas within a cell? 5
Help with Sumproduct or Rank 1

Top