EXCEL Formula

T

Timjay

Joined
Aug 27, 2015
Messages
2
Reaction score
0
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
 
Last edited:
Hi Ali
Thanks for that but it returned a VALUE when I tried it
I have shown what I need below
Thanks
Tim J
upload_2015-9-1_12-44-31.webp
 

Attachments

  • upload_2015-9-1_12-34-53.webp
    upload_2015-9-1_12-34-53.webp
    59.8 KB · Views: 105
  • upload_2015-9-1_12-34-54.webp
    upload_2015-9-1_12-34-54.webp
    59.8 KB · Views: 185
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)),"")
 
Back
Top