The FORMULATEXT function is often dismissed because it merely transforms a formula into text. However, that raw text is exactly what makes it so valuable. So, stop thinking of it as a one-trick ...
Counting non-empty cellsThe COUNTBLANK-COUNTA conflict (and how to fix it)Summary: Choosing the right counting functionIn ...