3 ms·
Naming a single cell doesn't solve the problem of accidentally using a different range of values. In a normal programming language you would define a variable s
by andreasvc 14y ago
Naming a single cell doesn't solve the problem of accidentally using a different range of values. In a normal programming language you would define a variable such as GDP containing a list of values for the countries of interest, in Excel every formula has to restate the range, which is what caused the mistake.
- LyndsySimon 14y agoThat's not the case. You can have named ranges in Excel - in fact, you can have named ranges which are dynamically calculated based on a formula.