Hi Volker On Fri, Mar 21, 2014 at 1:31 AM, Volker Strobel <volker.strobe...@gmail.com> wrote: > My problem is, that this remote reference starts in row 3 (because of @$#), > however, I'd like to start in row 2 (that means @$#-1). However, this > relative reference does not seem to work here.
Calculation within the field reference of Org is not supported but subscr of Calc can be used to pick calculated references from a range: #+NAME: my-table | Header1 | Header2 | |---------+---------| | a | 23 | | b | 7 | | c | 13 | | d | 66 | | e | 5 | |---------+---------| | Result | 42 | | x | y | 23 | 7 | 13 | 66 | 5 | #+TBLFM: @1$3..@1$7 = subscr(remote(my-table, @2$2..6$2), $# - 2) (To show the intermediade step: | x | y | [23, 7, 13, 66, 5] | [23, 7, 13, 66, 5] | #+TBLFM: @1$3..@1$4 = remote(my-table, @2$2..6$2) ) Michael
