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
---------------------------------------------------------
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
---------------------------------------------------------
No comments:
Post a Comment