Quote:
Originally Posted by Pecoflyer
Sorry I don't understand German - Difficult to help under these circumstances
|
How so? This is about a formula, you don't have to know what the texts mean
Quote:
Originally Posted by ArviLaanemets
So you may have some cells not filled jet? Then I'm afraid you are ot of luck!
Imagine a case, you have a cotinous row of dates with all 3 rows having 1 entered, and somewhere in middle cells in row 24:25 in some column are unchecked. You have go back to first column with 1 in row 26, and then check the full path back until the column with empty cells to decide, do those belong to this or previous column. Add one checked column more, and you have a step more to calculate.
Probably you have to add 2 more rows - 2 meals from current day, a night, and 2 meals from next day. And in column you can have 3 1's altogether.
|
Yes, every month different cells are gonna be either blank or have a 1 in them.. It always belongs to the column where row 26 has a 1 in it. I'll try the more rows Thing but I'm not sure about it.