3 ms·
Excel also has named rows/columns and cells - one of the bunch of useful tips I learned from Joel Spolsky's "You Suck at Excel" presentation - here's the part w
by mmc 9y ago
Excel also has named rows/columns and cells - one of the bunch of useful tips I learned from Joel Spolsky's "You Suck at Excel" presentation - here's the part where he covers that: https://youtu.be/0nbkaYsR94c?t=25m54s https://youtu.be/0nbkaYsR94c?t=25m54s
- deleted 9y ago[deleted]
- mschaef 9y agoExcel also supports Multiplan-style RC syntax for cell addresses, if you like. I find the syntax a bit more clear, but ultimately too verbose to be useful. R1C1 = Row 1, Column 1. R[1]C[1] = cell one row over and one row down. One other point worth mentioning is that cell-relative references in Excel are more pervasive than they might appear. For example, you can specify a conditional format formula that highlights a cell if it has a different value than the cell immediately above. (Or a number of other more considerably complex scenarios.) Range names work this way too... it's possible to define a range of the form "three cells to the right of the current cell".
- apricot 9y agoMultiplan... now that's a name I haven't heard in a long time.