Friday, March 8, 2013

yogi_Set Up A Formula So That Data From Columns Of Rows 5 6 And 7 Is Automatically Concatenated Anfd Populated In Row 8

                                          Google Spreadsheet   Post  #1072
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Mar 8, 2013
user vif1000 :(http://productforums.google.com/forum/?zx=eycch1ookas1#!category-topic/docs/spreadsheets/qdvBm5RMN0k)
Continue formula in a row
Hi 

Maybe I am thinking wrong, but I need a continue formula, so I dont have to drag and copy formula forever.
This is what I need to continue: =B3&", "&B4&" "&B5
Next is with c, next with d and so on.
Maybe this formula =B3&", "&B4&" "&B5 should is not enough?

There is no answer to this in forum, after 4 hours searching.

Thanks for any help with this issue.
---
Ok, here is an example

I dont know how to explain the issue
---------------------------------------------------------------------------------------------
following is a solution to the problem

No comments:

Post a Comment