I used to see the double dash (--) in Excel spreadsheets and wonder what it did. It's an essential shortcut to force Excel to treat TRUE and FALSE as the numbers 1 and 0, meaning you can easily sum or ...
Whole-column references in Excel are silent performance killers, often forcing the program to manage a range of over a ...