Spreadsheet: 756742d1637754058-excel-formula-to-find-a-last-filled-cell-in-a-table-row-expenditures_fixed_charges
Sheet: VASTE_LASTEN

 |  |  |  |  |  |  |  | Total table column count: |  |  |  |  |  |  |  |  |  |  |  |  | Table row | Amounts in last filled table column | Table Column and address | Table column | Current last table column |  | Offset from today's column | Today's column | Real cell row in table | Cell address based upon today's date | Amount in column AE | Address Current amount for today | Address Prior  amount
 |  |  |  |  |  |  |  | Table column based on Today's  date: |  | 2019-12-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-25 00:00:00 | 2021-07-01 00:00:00 | 2021-10-29 00:00:00 | 2022-01-01 00:00:00
 | Soort Lasten | Omschrijving | P | Bedrag | Verschil | [NAME] |  | Omschrijving | P | Column 1 | Column 2 | Column 3 | Column 4 | Column 5 | Column 6 | Column 7
 | Cumul 0001 |  |  |  |  |  |  | Post 1 | 1 | 861.37 | 885.5 | 892.38 |  |  |  | 895 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $M$4 | $L$4
 | Cumul 0001 |  |  |  |  |  |  | Post 2 | 1 | 999.99 |  |  | 174 |  | 200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $P$5 | $[NAME]
 | Cumul 0002 |  |  |  |  |  |  | Post 3 | 1 | 249.55 | 270.32 | 284.13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $M$6 | $M$6
 | Cumul 0002 |  |  |  |  |  |  | Post 4 | 1 | 124.88 | 131.2 | 131.2 |  | 133.43 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $O$7 | $M$7
 | Cumul 0003 |  |  |  |  |  |  | Post 5 | 1 | 36.65 |  | 37.9 |  | 38.9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $O$8 | $M$8
 | Cumul 0003 |  |  |  |  |  |  | Post 6 | 1 | 56 | 58.5 | 59.5 |  | 60.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $O$9 | $M$9
 | Cumul 0003 |  |  |  |  |  |  | Post 7 | 1 | 13.5 | 13.78 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $M$10 | $M$10
 | Cumul 0003 |  |  |  |  |  |  | Post 8 | 1 | 13.5 | 13.78 | 15.47 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $M$11 | $M$11
 | Cumul 0003 |  |  |  |  |  |  | Post 9 | 1 |  | 18.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $L$12 | $L$12
 | Cumul 0003 |  |  |  |  |  |  | Post 10 | 1 |  | 15.95 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $L$13 | $L$13
 | Cumul 0004 |  |  |  |  |  |  | Post 11 | 1 | 13.75 | 14 | 14.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $M$14 | $M$14
 | Cumul 0004 |  |  |  |  |  |  | Post 12 | 1 | 13.75 | 14 | 14.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $M$15 | $M$15
 | Cumul 0004 |  |  |  |  |  |  | Post 13 | 1 | 13.75 | 14 | 14.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $M$16 | $M$16
 | Cumul 0005 |  |  |  |  |  |  | Post 14 | 1 | 200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $K$17 | $K$17
 | Cumul 0006 |  |  |  |  |  |  | Post 15 | 1 |  | 4.35 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $L$18 | $L$18
 | Cumul 0006 |  |  |  |  |  |  | Post 16 | 1 |  | 4.35 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $M$19 | $M$18
 | Cumul 0006 |  |  |  |  |  |  | Post 17 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $L$20 | $L$17
 | Cumul 0007 |  |  |  |  |  |  | Post 18 | 2 |  | 180 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $[NAME] | $L$18
 | Cumul 0007 |  |  |  |  |  |  | Post 19 | 2 |  | 81 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $L$22 | $[NAME]
 | Total |  |  |  |  |  |  | Total
 |  |  |  | 892.38 |  | 885.5
 |  |  |  | 200 |  | 174
 |  |  |  | 284.13 |  | 270.32
 |  |  |  | 133.43 |  | 131.2
 |  |  |  | 38.9 |  | 37.9
 |  |  |  | 60.5 |  | 59.5
 |  |  |  | 15 |  | 13.78
 |  |  |  | 15.47 |  | 13.78
 |  |  |  | 18.5 |  | 18.5
 |  |  |  | 15.95 |  | 15.95
 |  |  |  | 14.25 |  | 14
 |  |  |  | 14.25 |  | 14
 |  |  |  | 14.25 |  | 14
 |  |  |  | 200 |  | 200
 |  |  |  | 4.35 |  | 4.350000000000001
 |  |  |  | 5.35 |  | 4.35
 |  |  |  | 3.5 |  | 3.5
 |  |  |  | 60 |  | 60
 |  |  |  | 27 |  | 27