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