SOLVED

Unir dos rangos en uno solo

%3CLINGO-SUB%20id%3D%22lingo-sub-3256966%22%20slang%3D%22es-ES%22%3EJoin%20two%20ranges%20into%20one%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3256966%22%20slang%3D%22es-ES%22%3E%3CP%3EI%20need%20to%20know%20how%20I%20can%20join%20two%20or%20more%20ranks%20one%20after%20the%20other%20using%20formulas%2C%20I%20have%20searched%20the%20internet%20and%20I%20have%20not%20found%20a%20way%20to%20do%20it%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3256966%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3256985%22%20slang%3D%22en-US%22%3ERe%3A%20Unir%20dos%20rangos%20en%20uno%20solo%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3256985%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1333103%22%20target%3D%22_blank%22%3E%40flopez35%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUsing%20Excel%20365%20the%20content%20of%20the%20two%20ranges%20may%20be%20combined%20to%20give%20an%20array%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3D%20LET(%0A%20%20%20%20m%2C%20ROWS(range1)%2C%0A%20%20%20%20n%2C%20ROWS(range2)%2C%0A%20%20%20%20k%2C%20SEQUENCE(m%2Bn)%2C%0A%20%20%20%20IF(k%26lt%3B%3Dm%2C%20INDEX(range1%2Ck)%2C%20INDEX(range2%2Ck-m))%0A%20%20)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
New Contributor

Necesito saber como puedo unir dos o más rangos uno a continuación del otro utilizando fórmulas, he buscado en internet y no he encontrado una forma de hacerlo

1 Reply
best response confirmed by flopez35 (New Contributor)
Solution

@flopez35 

Using Excel 365 the content of the two ranges may be combined to give an array

= LET(
    m, ROWS(range1),
    n, ROWS(range2),
    k, SEQUENCE(m+n),
    IF(k<=m, INDEX(range1,k), INDEX(range2,k-m))
  )