L
linh091
I have this file and need to count the continuous date value (=1)
I already made for each month but cannot make for several months.
Now I need to help: how to make formula for B70 have the result as th
same B71
this file is generated automatically from an old software, and thi
sheet is very big and complicate with multi-cell, multi-table... Hence
it really hard to delete the gap as you can see because the tables ar
placed alternately
I just need: much better if there is a way can be inserted or combin
into the old formula a small formulas to be able to remove the characte
is not 0 or 1
https://www.dropbox.com/s/nuv9eqfnmrnvlft/Caculation the continuous date value.xlsx
Thank yo
I already made for each month but cannot make for several months.
Now I need to help: how to make formula for B70 have the result as th
same B71
this file is generated automatically from an old software, and thi
sheet is very big and complicate with multi-cell, multi-table... Hence
it really hard to delete the gap as you can see because the tables ar
placed alternately
I just need: much better if there is a way can be inserted or combin
into the old formula a small formulas to be able to remove the characte
is not 0 or 1
https://www.dropbox.com/s/nuv9eqfnmrnvlft/Caculation the continuous date value.xlsx
Thank yo