Ayudan

%3CLINGO-SUB%20id%3D%22lingo-sub-2200932%22%20slang%3D%22es-ES%22%3EHelp%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2200932%22%20slang%3D%22es-ES%22%3EHello%20everyone%20I%20need%20to%20be%20illustrated.%20I%20want%20to%20program%20an%20Exel%20box%20to%20place%20an%20%22X%22%20number%2C%20and%20such%20number%20%22X%22%20will%20make%20the%20limit%20dd%20a%20sequence%20of%20number%20%3CBR%20%2F%3E%20I%20mean%20%3CBR%20%2F%3E%20X%2014%20then%201.2.3.4.5.6.7%208.9.10.11.12.13.14%20%3CBR%20%2F%3E%20X%20x%204%20then%201.2.3.4%20The%20number%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20that%20varyes%20is%20x%20and%20this%20will%20be%20the%20times%20it%20will%20generate%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2200932%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor
Hola a todos necesito que me ilustren . Quiero programa una casilla de Exel para colocar un número "X" , y tal número "X" va hacer el límite dd una secuencia de número
Es decir
X= 14 entonces 1.2.3.4.5.6.7.8.9.10.11.12.13.14
X = 4 entonces 1.2.3.4

El número que varíe es x y este será la veces que generará
1 Reply
If you have office 365, then I think you could use the textjoin and sequence functions (I don't have sequence, but I think this would be how it would look if A1=14):
=textjoin(".",,sequence(A1))

Otherwise, I know this will work if you at least have textjoin (office 2016):
=textjoin(".",,row(indirect("1:"&A1)))

And, if you don't have textjoin, then I'm not sure you can do it with native excel functions and would have to resort to a vba user defined function.