Re: [O] org-table relative reference questions

[Jeffrey Brent McBeth]

On Tue, Apr 21, 2015 at 10:13:53AM +0200, Michael Brand wrote:
> Hi Jeffrey
> 
> On Mon, Apr 20, 2015 at 3:35 PM, Jeffrey Brent McBeth <address@hidden> wrote:
> > I'm looking for a way to reference a row or column on both the left
> > side and right side of a table formula that is "easily" manipulable.
> 
> As you noticed the left side is very limited compared to the right
> side. The solution below keeps the left side simple. "x" is used as a
> movable marker to indicate the beginning of the range:
> 
> | F | A | B |  C |
> |---+---+---+----|
> | x | 1 | 3 |  4 |
> |   | 2 | 4 | 69 |
> |---+---+---+----|
> |   | 3 |   |    |
> #+TBLFM: @>$2 = vsum(subvec(@address@hidden, find(@address@hidden, x), 0)); E
> :: @<<$4..@>>$4 = if("$1" == "(x)", $-2 + $-1, $0)

That is awesome.  subvec and if seem to be two very powerful tools that I've 
missed as I've trawled the documentation.  Thank you so much.

Jeff

-- 
"The man who does not read good books has no advantage over 
 the man who cannot read them."
 -- Mark Twain