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
Setting column width in a table with a macro is not working 0
Number range as a percentage 2
Finding asymptote equation and how to draw them in excel 0
Trying to find additional ranges outside of min, max, and average 2
=average - eliminate the top and bottom number 5
Word macro that can call cells out of Excel for a find and replace 0
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0

Top