Aug 27 2020 06:22 PM
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
Aug 27 2020 07:36 PM
SolutionHello 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.
Aug 27 2020 08:53 PM
Thank you!
Your answer solved a friend's problem.
Aug 28 2020 05:08 AM
Aug 27 2020 07:36 PM
SolutionHello 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.