Forum Discussion
How do I filter data from one sheet to another based on dates?
Thank you for replying.
When I open your attached file the formula doesn't seem to have worked - all the cells are showing "#NAME?". I do have the latest version of excel so that shouldn't be an issue. Did that formula work for you?
So frustrating, it just seems like it's impossible to do!
What do you mean under the latest version of Excel? Is that for Android, Mac or Windows? If Windows is that Excel 2019 or you are on subscription model, i.e. Office 365? Formula will work for the latest case.
SergeiBaklan It's for Windows. When I click on the "Account" button and then "About Excel", it says it's "Microsoft Excel 2019". However, just below the "About Excel" button it says "Version 2009", so that's a little confusing as to which I'm actually running.
As variant, for such sample
enter into D15 formula
=IFERROR( INDEX(Table1[Review date], AGGREGATE(15,6,1/(Table1[[Review date]:[Review date]]<$D$2)* (ROW(Table1[Review date])-ROW(Table1[[#Headers],[Review date]])), ROW()-ROW($D$14)) ), "")drag it to the left and to the right. Apply proper formats to A15:F15 (formula will show dates for numbers and blank cells), after drag entire line A15:F15 down till empty space will appear. Or as needed to have some gap for future data in Table1.
Excel 2019 is the name of the product. Version 2009 is the build version of the product, after it in parentheses is concrete build number.