Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Array formula - nee help
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 the same B71 this file is generated automatically from an old software, and this 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 are placed alternately I just need: much better if there is a way can be inserted or combine into the old formula a small formulas to be able to remove the character is not 0 or 1 https://www.dropbox.com/s/nuv9eqfnmrnvlft/Caculation%20the%20continuous%20date%20value.xlsx Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array formula SUMIF with 2D sum_range array | Excel Worksheet Functions | |||
Array formula: how to join 2 ranges together to form one array? | Excel Worksheet Functions | |||
Find specific value in array of array formula | Excel Worksheet Functions | |||
copy one array formula to an array range | Excel Programming | |||
Tricky array formula issue - Using array formula on one cell, then autofilling down a range | Excel Programming |