Forum Discussion
Excel Filter Function- Restricted to 5000 rows
Hello, I am trying to use the new filter function on a table which contains 20K Lines. It looks this function is restricted to 5000 Line item. When I provide the range with in 5K rows , I am gett...
You may perform small experiment.
New workbook, 1 in A1, in A2 enter =A1+1, Ctrl+Shift+Down, Ctrl+D. Now you have 1 048 576 rows in data.
Go to B1 and enter =FILTER(A:A,A:A>100000). It returns 948 576 rows of data.
Thanks, I did and it worked. I found that if the array have value #N/A, then filter function is throwing error.