Highest and lowest value from column

  • Thread starter Thread starter DrB
  • Start date Start date
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.
 
=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)
 
Back
Top