Forum Discussion
How do I filter data from one sheet to another based on dates?
I have a set of data which shows what dates risk assessments are due. I want to have 4 sheets; Sheet 1 for the master data, Sheet 2 to show overdue risk assessments, Sheet 3 to show which risk assess...
Yes, it does work for me.
I suspect you may not have the most recent. Try entering =FILTER and see what happens. If you have a version that supports that, it will (as it does for other functions) start prompting you to complete the formula.
mathetes The only option it gives me if =FILTERXML, not =FILTER. Does that make a difference?
These are functions with different functionality. FILTERXML parses the XML expression. FILTER filters data range based on defined condition and returns result to another range in the sheet.
