Re:Damn Excel – How the 'most important application' is ruin...
by andreasvc on Saturday April 20, 2013 @09:32PM
(#5583505)
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.
[ Parent
| on HN ]
Re:Damn Excel – How the 'most important application' is ruin...
by LyndsySimon on Sunday April 21, 2013 @01:52AM
(#5584020)
That'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.