Forum Discussion
FILTER Function Lagging, alternative function for this case?
Hi all, This is really difficult for me to explain, but i've tried my best. If anyone can help, I will be eternally grateful and you will save my sanity. I have the attached sheet which is a ...
FILTER may not be the best fit for this task, but I don't believe it's causing a "lag" in the workbook. I timed several full recalculations on the workbook and the average time was about .15 seconds.
Are you referring to a "lag" in navigating the sheet and moving from cell to cell, etc.? The sheet does have a lot of objects (200+) that will slow navigation: