Forum Discussion

Copper Contributor

Nov 11, 2022

Solved

how to stack part of named arrays/

hi, I have two named arrays, Array1 and Array2, and I want to stack row#3 from the first array +Row #4 from the second array
i.e
=Vstack(row#3@Array1, Row#4@Array2)
what is the syntax to be written?

excel

Formulas and Functions

Riny_van_Eekelen
Nov 11, 2022
AlaaElmahmoudy That would be:
=VSTACK(CHOOSEROWS(Array1,3),CHOOSEROWS(Array2,4))

4 Replies

Riny_van_Eekelen
Platinum Contributor
Nov 11, 2022
AlaaElmahmoudy That would be:
=VSTACK(CHOOSEROWS(Array1,3),CHOOSEROWS(Array2,4))
- AlaaElmahmoudy
  Copper Contributor
  Nov 11, 2022
  Thank you very much, may I ask another two questions?
  1 - I have Array and want to sum the total of each column but exclude the first row (header).
  2 - How to use this syntax but exclude certain rows (as I have many rows and I need to exclude few)?
  - Riny_van_Eekelen
    Platinum Contributor
    Nov 11, 2022
    AlaaElmahmoudy Please provide some more information. A screenshot of a link to a file with an example of such an array and on showing which rows need to be summed.