Quote:
Originally Posted by ArviLaanemets
An example:
Code:
Row ... DayA DayB DayC DayD DayE ...
24 ... 1 1 1 1
25 ... 1 1 1 1
26 ... 1 1 1 1 1
Now the question is, do belong these empty cells to DayB, or to DayC? No way to decide based only on DayB : DayC columns, without processing all days at least from start of block of 1's, when not from start of table. And what when the block starts with halfway filled data? P.e. in my example in column DayA the row 24 is empty, but really not filled jet.
|
Hello
The empty cells should belong to Day B
So I have 3 extra rows now with:
1) 2 Meals before night (easiest, no help needed with this one)
2) 1 Meal before and after night
3) 2 Meals after night
So it now just counts those 3 "possibilities" and I have them on paper now. What I now Need is some Kind of Formula that can calculate if there's only one refund or two in complicated cases like this one:
Row ... .......A......B......C.......D.......E ...
24 .............................1
25 ......................1......1
26 ......................1......1
...
30 ......................>Formula<
My Problem is this:
The example up there is one refund, right? Because B26, C24, C25 are one refund OR C24,C25,C26 could be one refund, but it's only one of either. The way I'm going now, it recognizes "B" and "C" as a refund, which I don't want.. So I would Need something like: If B30 is 1 due to C24 and C25 belonging to it, then don't put 1 in C30
Does something like this exist? I can upload the file again if you want.