I am struggling with getting the formula to behave as I want it to, and would really appreciate any help you can offer please?
I have an array formula in a spreadsheet but it does not increment the values through each of the rows although it does populate all rows;
the formula is
The data columns are
Event, Start Date, End Date, Zulu Date, Zulu Start, Zulu End
Here is a link to example spreadsheet