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 have:
IFERROR(INDEX($A$2:$I$2,SMALL(IF($A$1:$I$2=TRUE,ROW($A$1:$I$2)-MIN(ROW(1:1))+1),COLUMNS($A:A))),"")
I then copy this formula across to R2
The formula is almost correct in the sense that it displays the correct number of TRUE results, i.e. J2=C#9 K2=C#9 L2=C#9 M2=C#9
However the correct result should be J2=C#9, K2=C#7, L2=C#5, M2=C#3
Please show me where I am going wrong. I have tried all kinds of slight amendments to no avail and there is only limited help regarding this kind of query on the web.
Best regards
manc
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 have:
IFERROR(INDEX($A$2:$I$2,SMALL(IF($A$1:$I$2=TRUE,ROW($A$1:$I$2)-MIN(ROW(1:1))+1),COLUMNS($A:A))),"")
I then copy this formula across to R2
The formula is almost correct in the sense that it displays the correct number of TRUE results, i.e. J2=C#9 K2=C#9 L2=C#9 M2=C#9
However the correct result should be J2=C#9, K2=C#7, L2=C#5, M2=C#3
Please show me where I am going wrong. I have tried all kinds of slight amendments to no avail and there is only limited help regarding this kind of query on the web.
Best regards
manc