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. ...
James2020 That's odd. I just tried the FILTER function for over 100 thousand rows. No problem.
Can you share the formula?
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!