Forum Discussion
VSTACK and SORT
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.
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.
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.
Harun24HR I have tried having the format type of the data be both "Short Date" and "General" Neither of those format types have yielded properly sorted data.
Strange - it works correctly when I try it.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
- I was planning on sending over a smaller data set with all the unnecessary columns and data removed, but when I created that and tested this out, it did work. So I am willing to send a version of the spreadsheet that does not have all the information, but I have not been able to recreate the issue in that setting.
I am wondering if this issue (the correct formula not working) is due to the data being incomplete in some cells. There are several cells that do not have dates.That shouldn't matter...
