Hello,
I am trying to design the sheet below to return----at each outline level----the lowest value beneath it OR return the value already at each outline level if it is in fact already the lowest value. It is the second part of this puzzle I can't figure out. I would appreciate any help!! Thanks.
I am trying to design the sheet below to return----at each outline level----the lowest value beneath it OR return the value already at each outline level if it is in fact already the lowest value. It is the second part of this puzzle I can't figure out. I would appreciate any help!! Thanks.
andrew_new.xls | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | OutlineLevel | WBSNumber | RawData | HowDataisCurrentlyCalculating | HowDataNeedstobeCalculating | ||
2 | 0 | CurrentStatus | |||||
3 | 1 | Program(Level1) | 2 | 1 | 1 | ||
4 | 2 | Level2(3.2) | 2 | 1 | 1 | ||
5 | 3 | Level3(3.7) | 2 | 3 | 2 | ||
6 | 4 | 3.2.9.9 | 3 | 0 | 0 | ||
7 | 4 | 3.7.1.9.1.1 | 3 | 0 | 0 | ||
8 | 3 | Level3(3.7) | 1 | 2 | 1 | ||
9 | 4 | 3.2.9.9 | 3 | 2 | 2 | ||
10 | 5 | 3.7.1.9.10 | 3 | 0 | 0 | ||
11 | 5 | 3.5.12 | 2 | 0 | 0 | ||
12 | 4 | 3.7.1.9.1.2 | 3 | 0 | 0 | ||
13 | 4 | 3.7.1.9.11.4 | 2 | 0 | 0 | ||
14 | 4 | 3.7.1.9.11.5 | 3 | 0 | 0 | ||
15 | 4 | 3.7.1.9.11.6 | 3 | 0 | 0 | ||
16 | 4 | 3.7.1.9.11.7 | 3 | 0 | 0 | ||
17 | 4 | 3.7.1.9.11.8 | 3 | 0 | 0 | ||
18 | 3 | Level3(3.7) | 2 | 1 | 1 | ||
19 | 4 | 3.2.9.9 | 1 | 0 | 0 | ||
20 | 4 | 3.7.1.9.1.6 | 3 | 0 | 0 | ||
21 | 3 | Level3(3.7) | 2 | 3 | 2 | ||
22 | 4 | 3.2.9.9 | 3 | 0 | 0 | ||
23 | 4 | 3.7.1.9.1.7 | 3 | 0 | 0 | ||
24 | |||||||
25 | 1 | ||||||
26 | 2 | ||||||
27 | 3 | ||||||
28 | 4 | ||||||
29 | 5 | ||||||
Sheet1 |