Friday, February 21, 2014

yogi_Extract The Last Non-Zero Number From H3 to H That May Contain Numbers As Well As Text Entries

                                         Google Spreadsheet   Post  #1542
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Feb-21-2014
post by  Mike Ladouceur  (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/OFWcRkp2IbI)
Getting the last item in a list
I'd like to have a cell get the last item in a list. They're all dollar values and if it's $0.00 it seems it sets the cell to $0.

Example:

H3=$1000.00
H4=$1200.00
H5=$1100.00
H6=$0.00

then F1=$1100.00

----------------------------------------------------------------------------------------------------------------------------------------------------
following is the solution to a bit more generalized problem