[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[O] Table calculation
From: |
Brett Presnell |
Subject: |
[O] Table calculation |
Date: |
Sat, 20 Feb 2016 14:41:58 -0500 |
User-agent: |
mu4e 0.9.16; emacs 25.1.50.2 |
In the following table, the last row gives the number of empty cells
following the last nonempty cell in each column (except the first column
of course). I would like to create a TBLFM formula that does this
calculation for me automatically. Some time ago I tried using
org-lookup-last and org-lookup-all for this, but I never got it to work.
Any ideas/solutions?
| Date | AA | BB | CC | DD | EE | FF | GG | HH | II | JJ | KK | LL | MM |
|--------+----+----+----+----+----+----+----+----+----+----+----+----+----|
| / | <> | <> | <> | <> | <> | <> | <> | <> | <> | <> | <> | <> | <> |
| 201005 | | | | | 1 | | | 1 | | | | 1 | |
| 201008 | | | | 1 | | | | | | | | | |
| 201012 | | | | | | | | | | | | | |
| 201105 | | | | | | 1 | | | | | | | |
| 201108 | | | | | | | 1 | | | | | | |
| 201112 | | | | | | | | | | 1 | | | |
| 201205 | | | | | | | | | | | | | |
| 201208 | | | | | | | | | | | | | |
| 201212 | | | | | | | | | 1 | | | | |
| 201305 | | | 1 | | | | | 2 | | | 1 | | |
| 201308 | 1 | | | | | | | | | | | | |
| 201312 | | | | | | | | | | | | | 1 |
| 201405 | | | | | | | | 1 | | | | 1 | |
| 201408 | | 1 | | | | | | | | | | | |
| 201412 | | | | | 1 | | | | | | | | |
| 201505 | | | | 1 | | | | | | | | | |
| 201508 | | | | | | | | | 1 | | | | |
| 201512 | | | | | | | 1 | | | | | | |
| 201605 | | | | | | | | | | | | | |
|--------+----+----+----+----+----+----+----+----+----+----+----+----+----|
| | 8 | 5 | 9 | 3 | 4 | 15 | 1 | 6 | 2 | 13 | 9 | 6 | 7 |
- [O] Table calculation,
Brett Presnell <=