Hi guys, I need to create a short schedule about my backlog in my DB. As you can see I have 5 category ( PWHT ,MPI/PT, HT, RT, UT ) with a little backlog
( PWHT 4 , MPI/PT 0 , HT 7 , RT 16, UT 0 .) and I want to see only Backlog Lines from my DB.
DB range in Sheet1 A2:CC367 and also after some time can be bigger than this. How I can do that or which formula can help me ?
Thank you.
( PWHT 4 , MPI/PT 0 , HT 7 , RT 16, UT 0 .) and I want to see only Backlog Lines from my DB.
DB range in Sheet1 A2:CC367 and also after some time can be bigger than this. How I can do that or which formula can help me ?
Thank you.
TIE-IN Welding Log SD 2021 W.xlsx | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
1 | Backlog | |||||||||||
2 | PWHT | MPI/PT | HT | RT | UT | |||||||
3 | Requested | 11 | 66 | 71 | 100 | 5 | ||||||
4 | Performed | 7 | 66 | 64 | 84 | 5 | ||||||
5 | Backlog | 4 | 0 | 7 | 16 | 0 | ||||||
6 | ||||||||||||
7 | ARRAY OF TABLE | EXAMPLE ( CAN BE CHANGE AFTER SOME TIME) | A2:CC367 | |||||||||
8 | ALL INFO IN ONE LINE | EXAMPLE | A2:CC2 | |||||||||
9 | № | PWHT | ||||||||||
10 | 1 | A2:CC2 | A2:CC2 | A2:CC2 | A2:CC2 | A2:CC2 | A2:CC2 | A2:CC2 | A2:CC2 | and E.T.C | ||
11 | 2 | A15:CC15 | A15:CC15 | A15:CC15 | A15:CC15 | A15:CC15 | A15:CC15 | A15:CC15 | A15:CC15 | and E.T.C | ||
12 | 3 | A107:CC107 | A107:CC107 | A107:CC107 | A107:CC107 | A107:CC107 | A107:CC107 | A107:CC107 | A107:CC107 | and E.T.C | ||
13 | 4 | A208:CC208 | A208:CC208 | A208:CC208 | A208:CC208 | A208:CC208 | A208:CC208 | A208:CC208 | A208:CC208 | and E.T.C | ||
14 | № | HT | ||||||||||
15 | 1 | |||||||||||
16 | 2 | |||||||||||
17 | 3 | |||||||||||
18 | 4 | |||||||||||
19 | 5 | |||||||||||
20 | 6 | |||||||||||
21 | 7 | |||||||||||
22 | № | RT | ||||||||||
23 | 1 | |||||||||||
24 | 2 | |||||||||||
25 | 3 | |||||||||||
26 | 4 | |||||||||||
27 | 5 | |||||||||||
28 | 6 | |||||||||||
29 | 7 | |||||||||||
30 | 8 | |||||||||||
31 | 9 | |||||||||||
32 | 10 | |||||||||||
33 | 11 | |||||||||||
34 | 12 | |||||||||||
35 | 13 | |||||||||||
36 | 14 | |||||||||||
37 | 15 | |||||||||||
38 | 16 | |||||||||||
NDT BackLog |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C3 | C3 | =COUNTA('Weld log'!BU2:BU1034) |
D3 | D3 | =COUNTA('Weld log'!BC59:BC1034) |
E3 | E3 | =COUNTA('Weld log'!BG59:BG1034) |
F3 | F3 | =COUNTA('Weld log'!BK59:BK1034) |
G3 | G3 | =COUNTA('Weld log'!BZ59:BZ1034) |
C4 | C4 | =COUNTA('Weld log'!BV59:BV1034) |
D4 | D4 | =COUNTA('Weld log'!BD59:BD1034) |
E4 | E4 | =COUNTA('Weld log'!BH59:BH1034) |
F4 | F4 | =COUNTA('Weld log'!BL59:BL1034) |
G4 | G4 | =COUNTA('Weld log'!CA67:CA1034) |
C5:G5 | C5 | =C3-C4 |
Last edited: