First I appologize if this has already been posted.
I need to find the First value and the last value of a range. A value is put into cell C12: number 1 for example and what happens is that excel will go down range H2:H9 and find the First Depth - "0" in this case and the last
Depth 100.
All help appreciated.
I need to find the First value and the last value of a range. A value is put into cell C12: number 1 for example and what happens is that excel will go down range H2:H9 and find the First Depth - "0" in this case and the last
Depth 100.
Daily Reporting Ver 1.0.3.xls | |||||||
---|---|---|---|---|---|---|---|
E | F | G | H | I | |||
1 | Code | Activity | BHA | Depth | |||
2 | 1 | Rigup/TearDown | 1 | 0 | |||
3 | 7 | RigService | 1 | 0 | |||
4 | 2 | Drilling | 1 | 100 | |||
5 | 6 | Trips | 2 | 100 | |||
6 | 15 | PressureTest | 2 | 100 | |||
7 | 4 | Coring | 2 | 100 | |||
8 | 2 | Drilling | 2 | 200 | |||
9 | 7 | RigService | 2 | 200 | |||
10 | |||||||
11 | |||||||
12 | BHAValue | 1 | |||||
13 | MinDepth | ||||||
14 | MaxDepth | ||||||
15 | |||||||
DailyReports |
All help appreciated.