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    Mar 15, 2013
user Dave Lalande :(!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.


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.


following is a solution to the problem