Your Excel sheets keep lagging because of these 3 formulas
https://www.makeuseof.com/excel-sheets-keep-lagging-because-of-these-formulas/
- Formulas with volatile functions. There’s a reason the pros use them sparingly
- Legacy array formulas. Processing array formulas is not always so simple
- Lookup formulas. They’re convenient but can be expensive
- Unlock the power of a fast Excel sheet