Whoever invented the A1 or even R1C1 addressing syntax perhaps made it easy for getting started or trivial formulas, but hard for anything else. The main problem is that it does not allow for ...