|
|
#5
11-06-2019, 12:08 AM
|
|||
|
|||
Having your workbook designed more database-like will work better. The current design is suspiciously like to any bookkeeping ledger from 1800+.
In attached example, you find 2 different formulas to calculate yearly amounts. The first works only, when year numbers in table don't have any gaps. The second one needs an additional helper column (RowNo, which can be hidden), and it allows gaps in year numbers. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Word 2007 - question that I am not able to describe - see sketch | Rumcajs997 | Word | 3 | 05-29-2019 05:16 AM |
| Auto Convert Text. I.E. Abbreviation to Complete Word (Hard to describe) | Chrisiztopher | Excel | 1 | 01-26-2017 08:38 AM |
| The most appropriate way to describe XML data in word. | Somyata | Word | 2 | 10-09-2014 11:13 PM |
| Word Question - not sure how to describe | CrzyIcE | Word | 1 | 04-05-2010 04:13 AM |
Windows 8 
Office 2016
Threaded Mode