Joker,

Array enter (enter using Ctrl-Shift-Enter)

=INDEX(AC:AC,MIN(IF(AC48:AC520,ROW(AC48:AC52))))

HTH,
Bernie
MS Excel MVP


"Joker" wrote in message
...
I am trying to find a formula which will return a value from a list which is
greater than 0. For example, from cell AC48:AC52, I need the first number
greater than 0 starting from the top. If AC48 = 0, AC49 = 100, AC50 = 20,
AC51 = 0, and AC52 = 0. I need a formula to find AC49's value of 100. Thank
you