Quote:
Originally Posted by Ylli
It always belongs to the column where row 26 has a 1 in it..
|
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.
12-08-2017, 04:19 AM
Similar Threads
Help needed with IF formula with a Vlookup
Windows 8 
Office 2016
Threaded Mode