Forum Discussion
VSTACK and SORT
I have a spreadsheet with many (27) sheets where all the columns in each sheet are the same. I have created a dashboard using VSTACK to show all the data from all the sheets on a single page.
=VSTACK(Table1, Table2, Table3....Table27). Column G on the dashboard lists dues dates, and I would like to be able to sort the entire dashboard by column G.
The end result should be a dashboard that shows all the data from all the sheets and lists the rows in chronological order according to column G. I have tried to add a SORT function in front of the VSTACK with no luck (produces a #VALUE! error).
Did you try
=SORT(VSTACK(Table1, Table2, Table3....Table27), 7)
to sort on column G in ascending order, or
=SORT(VSTACK(Table1, Table2, Table3....Table27), 7, -1)
to sort on column G in descending order.
8 Replies
Did you try
=SORT(VSTACK(Table1, Table2, Table3....Table27), 7)
to sort on column G in ascending order, or
=SORT(VSTACK(Table1, Table2, Table3....Table27), 7, -1)
to sort on column G in descending order.
- I have, and the column that I am trying to sort by does not appear in chronological order. It appears like the following.
9/27/2024
10/6/2024
10/6/2024
10/18/2024
10/15/2024
10/18/2024
10/18/2024
9/29/2024- Are these true date values or TEXT values looks like date? If they are true dates then it must works.
