Forum Discussion
mshakeeb
Feb 23, 2021Copper Contributor
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...
mshakeeb
Feb 24, 2021Copper Contributor
SergeiBaklan mathetes .. Thanks for your help and i used ISERROR function to get it fixed.
SergeiBaklan
Feb 26, 2021Diamond Contributor
Thank you for the update. I only tried to illustrate that FILTER() has no formal limit on rows number.