Forum Discussion

andyyporter's avatar
andyyporter
Copper Contributor
Oct 22, 2020

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...
excel
Formulas and Functions
andyyporter's avatar
andyyporter
Copper Contributor
Oct 22, 2020

mathetes 

 

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!

 

 

 

 

mathetes's avatar
mathetes
Gold Contributor
Oct 22, 2020

andyyporter 

 

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.

  • andyyporter's avatar
    andyyporter
    Copper Contributor
    Oct 23, 2020

    mathetes The only option it gives me if =FILTERXML, not =FILTER. Does that make a difference?

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Oct 23, 2020

      andyyporter 

      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.