software

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

Joker,

Array enter (enter using Ctrl-Shift-Enter)

=INDEX(AC:AC,MIN(IF(AC48:AC52gt;0,ROW(AC48:AC52))))

HTH,
Bernie
MS Excel MVPquot;Jokerquot; gt; wrote in message
...
gt;I am trying to find a formula which will return a value from a list which is
gt; greater than 0. For example, from cell AC48:AC52, I need the first number
gt; greater than 0 starting from the top. If AC48 = 0, AC49 = 100, AC50 = 20,
gt; AC51 = 0, and AC52 = 0. I need a formula to find AC49's value of 100. Thank
gt; you
You can use the AutoFilter. Datagt;gt;Filtergt;gt;Autofilter. Autofilter places
arrows at the top of your column. Click on the arrow at the top of your
column and select quot;customquot; and select greater than on the left and type 0 on
the right. One caution though, Autofilter only works on the first 1000 rows.

quot;Jokerquot; wrote:

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