One of the repeating problems I've noticed recently are formulas that are not written efficiently. Efficiency means writing formulas that are quick to write, easy to update, and intuitive.
This article describes some techniques for writing efficient formulas, including:
- Absolute vs Relative references.
- Named ranges.
- Excel tables.
- Column number and row number arguments.