Formula to get row # with last non-zero value

[rizmomin]

Hello:

Please refer to attached file.
I need formula in cell c1 to give the last row# in column B with last non-zero value.

In this case answer needs to be Row # 9

Let me know if you have any questions.
Thanks.

Riz

[José Augusto]

Hi

Try this formula

Please Login or Register  to view this content.

[Pete_UK]

Hello again Riz,

Try this array* formula in C1:

=MAX(IF(B2:B11>0,ROW(B2:B11)))

*Note that an array formula needs to be committed using the key combination of Ctrl-Shift-Enter (CSE), rather than the usual < enter >.

Hope this helps.

Pete

[sohaila]

Try this formula
=LARGE(IF($B$1:$B$11<>0,ROW($B$1:$B$11)-ROW($B$1)+1),1) and press ctrl shift enter

[rizmomin]

Hello Pete & Jose:
Thanks a lot

Riz