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...
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.