Monday, August 15, 2011

yogi_Extract Penultimate (last but one) Non-Zero Entry From D5:D17

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  

Justadrumer said:
Next to last non zero from list ...
I need to know if there is a Google spreadsheet function that finds next to last text in a column. The column in question will only have one column filled with a text value and the rest of the values will be evaluated to zero. I found the following post which helped me get pull the last non zero from the column but I'd also like to pull the next to last as a separate result. Thoughts?