Nov 11 2022 12:38 AM
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?
Nov 11 2022 01:09 AM
Solution@AlaaElmahmoudy That would be:
=VSTACK(CHOOSEROWS(Array1,3),CHOOSEROWS(Array2,4))
Nov 11 2022 03:58 AM
Nov 11 2022 04:44 AM
@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.
Nov 11 2022 07:12 AM
Nov 11 2022 01:09 AM
Solution@AlaaElmahmoudy That would be:
=VSTACK(CHOOSEROWS(Array1,3),CHOOSEROWS(Array2,4))