Thanks for the formula, unfortunately it didn't return a value. I copied and
pasted the formula only modifying it to update the array range. Not sure
what I might have done to modify it so it's not working.

"Dave F" wrote:

=SMALL(A1:A50000,2) will return the 2nd smallest value.

Dave
--
Brevity is the soul of wit.


"willcozz" wrote:

I am trying to calculate the median value in a column of 51500 values, doing
so once for 83 separate columns. The formula =MEDIAN(array point 1:array
point 51500) works fine for most of the columns, but for others the system
returns a blank cell. There are data points in those arrays, so the blank
cell is confusing. Is there a way to instruct the system to look only at the
values with a whole number in the cell and to calculate the median from that
portion of the array, without sorting the column or modifying it?

Another approach would be to ask the system to return the MIN value. The
problem there lies in the fact that the system always presents zero as the
minimum, because is is. However to do the median calculation above I need
the smallest value above 0 in the array, is there a way to instruct the
system to present the smallest value above 0 in an array.