Download Excel File: https://excelisfun.net/files/EMT1861.xlsx
Download Timing Test file: https://excelisfun.net/files/EMT1861TestResults.xlsx
When extracting a sorted unique list with a formula, it is more efficient to use UNIQUE-SORT, rather than SORT-UNIQUE.
Topics:
1. (00:00) Introduction
2. SORT-UNIQUE combination tends to calculate slowly.
3. UNIQUE-SORT tends to calculate quickly.
4. () Summary
5. (02:32) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #sort #unique #arrayformulas #excelarrys #dynamicspilled arrays