Return last two non zero values in a column

[zalik22]

Hi,

I wanted to return the last two non-zero values in a column. So, if I have
1
2
3
4
5
0

I want a formula to return 5 and another formula to return 4. Would like to avoid array formulas if possible.

Thanks!

 

[Takae]

return5 =INDEX(A1:A6,MATCH(0,A1:A6,0)-1)
return4 =INDEX(A1:A6,MATCH(0,A1:A6,0)-2)

 

[zalik22]

Thanks! It worked.