emacs-orgmode
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[O] Sverweis like function for orgtbl


From: Thorsten Grothe
Subject: [O] Sverweis like function for orgtbl
Date: Mon, 16 Feb 2015 15:01:05 +0000 (UTC)
User-agent: Pan/0.139 (Sexual Chocolate; GIT bf56508 git://git.gnome.org/pan2)

Dear Org-users,

I got this table:

| Menge (x) | P(x) |   E(x) |   K(x) |  Gewinn |
|-----------+------+--------+--------+---------|
|         0 |   20 | 0.00   | 140.00 | -140.00 |
|        10 |   18 | 180.00 | 180.00 | 0.00    |
|        20 |   16 | 320.00 | 220.00 | 100.00  |
|        30 |   14 | 420.00 | 260.00 | 160.00  |

and would like to find the highest value in the column "Gewinn" = 160 go 
two cells left to E(x), read out the value (420) and put this in a remote 
orgtbl. This is something similar to Sverweis in Excel.

I found no predefined function for orgtbl, is it possible?

Thanks in advance!

Regards
Thorsten




reply via email to

[Prev in Thread] Current Thread [Next in Thread]