Forum Discussion

James2020's avatar
James2020
Copper Contributor
Feb 01, 2022

Excel FILTER formula limits

Hi!
I have been using the FILTER function without issue, except that my dataset has expanded to c 500 rows.  Once I try to use the function on the array with more than 345 rows I get an #N/A error.  Works fine below that.
Is this a limitation on the formula or something else?
Thanks!

excel
Formulas and Functions
  • HiteshShah1412's avatar
    HiteshShah1412
    Copper Contributor
    Apr 15, 2025

    I am receiving the same #N/A error for certain fields only. on detailed analysis found that your data base field cannot have #N/A in the filtered field results.

    • James2020's avatar
      James2020
      Copper Contributor
      Feb 01, 2022

      Thanks Riny_van_Eekelen 

       

      I spotted the issue in the end - a couple of rogue data points in the middle of the array throwing it off - all resolved now!

Resources