Share via

EXCEL Filter Function Finding Data Between Two Dates EXCLUDING Missing Data Reported as "#N/A"

Anonymous
2023-03-24T15:45:16+00:00

I have an array with multiple columns, two of which are headed as "Date" and "Steps". I wish to use the Filter Function to list the Step data between two dates EXCLUDING dates where the corresponding Steps data is not available and is recorded as #N/A

I start with =Filter(Steps,(Date>Early Date)*(Date<Later Date)) and this works great but does not exclude dates where Steps data is missing. How do I modify the filter formula to exclude Steps data recorded as "#N/A"

Or ... is there another formula which accomplishes?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2023-03-24T16:34:32+00:00

    =FILTER(G2:G12,(A2:A12>I1)*(A2:A12<J1)*(NOT(ISERROR(G2:G12))),"")

    5 people found this answer helpful.
    0 comments

6 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-03-24T16:43:28+00:00

    PERSONAL THANKS .... it worked great ... I am impressed, pleased, and relieved!

    0 comments
  2. Anonymous
    2023-03-24T16:50:29+00:00

    You are welcome:)

    0 comments