EXCEL Formula

[Timjay]

Which command do I use to get excel to identify the fist cell in a string of horizontal cells which returns a value of less than 8. and then reads and displays the column heading it is in. For example to read stage 7 6 etc
S4 S5 S6 S7 S8
8 8 8 7 3 S7
8 8 6 4 0 S6
8 8 3 0 0 S6
8 8 6 5 0 S6
8 8 8 5 3 S7

 

[salim Ali]

suppose the data is in A1:A100
enter this formula
=IF(A1<>"",LEFT(SUBSTITUTE(A1,8,""),1),"")

 

[Timjay]

Hi Ali
Thanks for that but it returned a VALUE when I tried it
I have shown what I need below
Thanks
Tim J

 

[salim Ali]

Enter this formula in H2 (with Ctrl+shift + Enter) an drag down
=IF($C2<>"",INDEX($C$1:$G$1,MATCH(FALSE,$C2:$G2=8,0)),"")