Highest and lowest value from column

D

DrB

I have a column of numbers including blanks where I want to put into another
cell the highest and into another cell the lowest (ignoring the blank or a
zero value) number from the column, then take the difference and put into a
third cell. I can do the latter but have not figured out to do the former.
Help.
 
P

Peo Sjoblom

=MAX(Range)

=MIN(Range)

if there are zeros present and you don't wan't a zero
and there are no negative numbers

=SMALL(A1:A10,COUNTIF(A1:A10,0)+1)
 

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

Excel What Function shows value between highest and lowest number 2
MIN will not find lowest of calculated values How? 5
Highest & lowest place value / decimal places of cell value 2
MIN/MAX and Lookup 2
Average of values in row excluding the highest and lowest value? 18
Scores of a Range Cells. Highest or lowest depending a parameter 1
highlight the highest cell in a column 1
Rank where lowest value is highest rank 2

Top