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. Works fine below that.
Is this a limitation on the formula or something else?
Thanks!
5 Replies
How do I drag a formula in a cell over 200,000 rows without copying and dragging it, which takes forever?
Assuming your formula in B2. Select 200000 rows down starting from B2 and Ctrl+D.
You may select range manually, or stay on B2-> in Name Box (left to the formula bar) type B2:B200002 -> Enter -> Ctrl+D
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 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!
