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