Forum Discussion

flopez35's avatar
flopez35
Copper Contributor
Mar 14, 2022

Unir dos rangos en uno solo

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

Excel
Formulas and Functions
  • PeterBartholomew1's avatar
    PeterBartholomew1
    Mar 14, 2022

    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))
  )
  • PeterBartholomew1's avatar
    PeterBartholomew1
    Silver Contributor
    Mar 14, 2022

    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))
  )
      • PeterBartholomew1's avatar
        PeterBartholomew1
        Silver Contributor
        Apr 22, 2024

        PakitoGARRIDO 

        It is still quite possible to use SEQUENCE and modify the formula to pickup data from the correct array but newer array shaping functions may offer a better solution.  For example

        = VSTACK(range1, range2, range3, range4)

        If the number of ranges is variable, but they lie within an overall containing range then

        = TOCOL(containingRange,1,TRUE)

        would be preferable.

Share

Resources