Filter function with large file

[jackidip]

Good afternoon. I usually work with large spreadsheets and find that when I use the FILTER option, i get a warning saying "not all items showing." Is there a way to see all the records instead of just the first 10,000? Thanks!

[misha4334]

If you have blank rows or columns it could cause an issue, or if there are blank cells within a column being filtered I've seen issues