|
|
|
|
|
by mschaef
3162 days ago
|
|
Excel 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". |
|