Google Spreadsheet Post #1082
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Mar 15, 2013
user Dave Lalande :(http://productforums.google.com/forum/?zx=lrxr3ogavken#!category-topic/docs/spreadsheets/7dHGnbtrh2E)
Formula help...
I need a formula find the last cell in a given column there is a number and then this cell is equal the concatenate of three other text cells.
So...
d2 = December 2012
d3 = January 2013
d4 = February 2013
d5 = no text
Then cell X (where formula is) = December 2012, January 2013, February 2013
Here is a sheet that I made to highlight the formula need. I've tried all kinds of combination using various functions and I can't get it.
Thanks,
Dave
--------------------------------------------------------------------------------------------------------------
following is a solution to the problem
No comments:
Post a Comment