ArrayFormula Not incrementing

1

Hi Guys,
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
={“Zulu Date”;ARRAYFORMULA(IF(A2:A<>"",CONCATENATE(E2&"/"&F2),""))}

The data columns are
Event, Start Date, End Date, Zulu Date, Zulu Start, Zulu End

Here is a link to example spreadsheet

Many Thanks

Rob

2 
={"Zulu Date";ARRAYFORMULA(IF(A2:A<>"",E2:E&"/"&F2:F,""))}

It should have been E2:E instead of E2 and F2:F instead of F2, also you should do it like the way above instead of concatenating.

3

ThinhDinh,
Many thanks that works great
Thank you

Rob

1 Like