Monday, August 15, 2011

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

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

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?http://www.google.ru/support/forum/p/Google+Docs/thread?tid=2b2c982b8ac59299&hl=en
---------------------------------------------------------