3 ms·
R1C1 isn't much different than normal calculation. You can already use $ for absolute row / column references.
by jldugger 10y ago
R1C1 isn't much different than normal calculation. You can already use $ for absolute row / column references.
- Tomte 10y agoThe point is that it is much more intuitively understandable what happens when you fill whole columns with that formula. In R1C1 notation it's obvious because the formula doesn't change. In normal notation the exact same thing happens under the hood, but the cell references you're seeing change.
- jldugger 10y agoMaybe, but named ranges make the whole thing somewhat moot. Your formulas should be human readable, ideally.