|
|
|
|
|
|
by andreasvc
4805 days 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. |
|
|
You can have named ranges in Excel - in fact, you can have named ranges which are dynamically calculated based on a formula.