Good afternoon,
Really struggling with this guys, hope you can help.
My data is as follows:
A1:c#9 B1:c#8 C1:c#7 D1:c#6 E1:c#5 F1:c#4 G1:c#3 H1:c#2 I1:c#1
A2:TRUE B2: FALSE C2: TRUE D2: FALSE E2: TRUE F2: FALSE G2:TRUE H2:FALSE I2:FALSE
My array formula has to go horizontally, so in F2 I...