SOLVED

change a cell reference

Copper Contributor

Good night!
I have a formula in cell H3, = CONCAT (G3: G10). There are 8 cells that will be concatenated (G3; G4; G5; G6; G7; G8; G9; G10). But I would like to vary the number of cells to be concatenated by changing this amount by typing in any cell. For example I would put the number 8 in cell G1 and the formula would concatenate from G3 to G10, but if I put 10 in cell G1 the formula would concatenate from G3 to G12. Does anyone know the solution?
Thank you.
Aparecido.
Brazil

3 Replies
best response confirmed by Cidoapis (Copper Contributor)
Solution

@Cidoapis 

Hello I hope I can assist you. 

=CONCAT(OFFSET(G2,0,0,G1,1))

 

If the answer is what you are looking for, don't be shy on hit the like button. 

@Juliano-Petrukio 

Thank you!
Your answer solved a friend's problem.

Good morning!
For Excell in Portuguese from Brazil, the formula was as follows:

=CONCAT(DESLOC(G3;0;0;$G$1;1))
1 best response

Accepted Solutions
best response confirmed by Cidoapis (Copper Contributor)
Solution

@Cidoapis 

Hello I hope I can assist you. 

=CONCAT(OFFSET(G2,0,0,G1,1))

 

If the answer is what you are looking for, don't be shy on hit the like button. 

View solution in original post