A
Allan from Melbourne
Many thanks to Bob Phillips for getting me this far.
Thanks, it's on the right track but not quite there. Placing your 1st
formula
=INDEX($1:$1,MIN(IF($E2:$AX2<>"",COLUMN($E2:$AX2)))) in A2 returns
the value 4 (E1). (see example below)
Then I place your new formula
=INDEX($1:$1,MAX(IF($A2:INDEX(2:2,MIN(IF($A2:$AX2<>"",COLUMN($A2:$AX2)))+4)<>"",COLUMN($A2:INDEX(2:2,MIN(IF($A2:$AX2<>"",COLUMN($A2:$AX2)))+4)))))
in B2 which returns the value 8 (I1). This is fine, what I now require is a
formula for C2 which will return the value 9 (J1) (this ignores what was
accounted for by the first two formulas A2 B2) and then another max formula
in D2 which will then return the value of 11 (L1). I then repeat these
formulas in the other rows. I hope
that this makes sence.
Thanks
Allan
A B C D E F G H I J K L M N O P
Thanks, it's on the right track but not quite there. Placing your 1st
formula
=INDEX($1:$1,MIN(IF($E2:$AX2<>"",COLUMN($E2:$AX2)))) in A2 returns
the value 4 (E1). (see example below)
Then I place your new formula
=INDEX($1:$1,MAX(IF($A2:INDEX(2:2,MIN(IF($A2:$AX2<>"",COLUMN($A2:$AX2)))+4)<>"",COLUMN($A2:INDEX(2:2,MIN(IF($A2:$AX2<>"",COLUMN($A2:$AX2)))+4)))))
in B2 which returns the value 8 (I1). This is fine, what I now require is a
formula for C2 which will return the value 9 (J1) (this ignores what was
accounted for by the first two formulas A2 B2) and then another max formula
in D2 which will then return the value of 11 (L1). I then repeat these
formulas in the other rows. I hope
that this makes sence.
Thanks
Allan
A B C D E F G H I J K L M N O P