Second last value from a contiguous range of cells

[hsandeep]

I have a contiguous column cells K2:V2. In Z72, I need an Excel formula such that it gets the 2nd last value from the range K72:V72 which should also be non zero and non blank else 0.
If required, I am ready to use helper rows / helper columns.

How to accomplish?
Thanks in advance

 

[Fluff]

How about

=IFERROR(INDEX($K2:$V2,AGGREGATE(14,6,(COLUMN(K$2:V$2)-COLUMN($K$2)+1)/($K2:$V2<>0),2)),"")

 

[hsandeep]

How about

=IFERROR(INDEX($K2:$V2,AGGREGATE(14,6,(COLUMN(K$2:V$2)-COLUMN($K$2)+1)/($K2:$V2<>0),2)),"")

Thanks Fluff...accurate

 

[Fluff]

You're welcome & thanks for the feedback.