I need help with this formula in excel, I keep getting a NAME error.

Anonymous
2024-03-26T12:15:26+00:00

=_xlfn._xlws.SORT(_xlfn._xlws.FILTER(Table3,(Table3[Name]=I2)*(Table3[Date]>TODAY()-365)),3)

Microsoft 365 and Office | Excel | Other | 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

8 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.7K Reputation points MVP Volunteer Moderator
    2024-03-26T12:28:18+00:00

    The prefix _xlfn. means that the formula uses functions (SORT and FILTER in your example) that are not available in your version of Excel.

    SORT and FILTER are available in Excel in Microsoft 365 and Office 2021, but not in older versions such as Office 2019, Office 2016 etc.

    The formulas would have to be completely rewritten to work in older versions.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2024-03-26T13:02:43+00:00

    Was this answer helpful?

    0 comments
  3. Anonymous
    2024-03-26T13:01:41+00:00

    Was this answer helpful?

    0 comments
  4. HansV 462.7K Reputation points MVP Volunteer Moderator
    2024-03-26T12:49:34+00:00

    Could you create a stripped-down copy of the workbook demonstrating the problem (without sensitive information) and make it available through one of the websites that let you upload and share a file, such as OneDrive, Google Drive, FileDropper or DropBox. Then post a link to the uploaded and shared file here.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2024-03-26T12:45:48+00:00

    Can you help me rewrite the formula?

    Was this answer helpful?

    0 comments