Friday, March 15, 2013

yogi_Create 3 Month Labels In Rows From Months In Column A By Offsetting From Latest Entry In Columns B And C


                                          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