Alternative for a filter formula

microsoft-excel worksheet-function microsoft-excel-2016 microsoft-excel-2019

Since the formula works, adjusting the search range should help to reduce the formula load. Try :

=FILTER(tab1!L1:L6000,tab1!K1:K6000="US")

Please share if it works/not.

Related

Ansible keyword - throttle
Bluetooth speaker paired successfully but services not showing - Windows 7
FTP clients (any) will hang on MLSD with passive mode in macOS Big Sur 11.4 and 11.5
How to add more of these yellow handles for the line tool in Visio?
Files Larger Than 4GB Are Not Transferring To Hard Drive?
BSPWM not Working on Ubuntu
How to clean hardware with an air compressor?
How to connect two remote computers with ssh
Unable to remove "orphaned" Clutter folder from Outlook 365 App (Version 2105)
How to list streams with FFmpeg?
How to batch copy "date modified" from files in directory to other files with identical names (but compressed) in another directory?
How to create new users in home partition?