Hi All,
hopefully somebody will be able to help me with the below;
<TBODY>
</TBODY>
The below formula will return the value of the first non blank cell in row 2:
=INDEX($A$1:$O$1,MATCH(TRUE,INDEX(($A2:$O2<>0),0),0)) Result: 01:00
The next formula returns he last non blank cell in row 2:
=LOOKUP(9.999999999E+307,$A2:$O2,$A$1:$O$1) Result: 06:00
I am looking for the start and end time of the first range and the start and end time of the second range.
Which formulas do I need to use to get
01:00-02:30 and 04:30-06:00.
any help is very much appreciated.
Bert.
hopefully somebody will be able to help me with the below;
00:00 | 00:30 | 01:00 | 01:30 | 02:00 | 02:30 | 03:00 | 03:30 | 04:00 | 04:30 | 05:00 | 05:30 | 06:00 | 06:30 | 07:00 |
2 | 5 | 6 | 6 | 8 | 8 | 7 | 9 |
<TBODY>
</TBODY>
The below formula will return the value of the first non blank cell in row 2:
=INDEX($A$1:$O$1,MATCH(TRUE,INDEX(($A2:$O2<>0),0),0)) Result: 01:00
The next formula returns he last non blank cell in row 2:
=LOOKUP(9.999999999E+307,$A2:$O2,$A$1:$O$1) Result: 06:00
I am looking for the start and end time of the first range and the start and end time of the second range.
Which formulas do I need to use to get
01:00-02:30 and 04:30-06:00.
any help is very much appreciated.
Bert.