Forum Discussion
Solved
Stacking spread out cells in Excel 2019
I am a user of Excel 365 and made a decently sized Excel sheet with a lot of calculations. However, one of the people I am making this calculation for doesn't have Excel 365 but owns Excel 2019. I ha...
If like this
it could be
=IFERROR( INDEX( $A$2:$A$100, AGGREGATE(15, 6, 1/($A$2:$A$100 <> "")*( ROW($A$2:$A$100) - ROW($A$1) ), ( ROW()-ROW($B$1) ) ) ), "")
SergeiBaklan Thank you for your response. It's almost what I need, except I don't want to sort them. I need the order in which they come.
If like this
it could be
=IFERROR( INDEX( $A$2:$A$100, AGGREGATE(15, 6, 1/($A$2:$A$100 <> "")*( ROW($A$2:$A$100) - ROW($A$1) ), ( ROW()-ROW($B$1) ) ) ), "")
