Backlog in DataBase.

Tofik

Board Regular
Joined
Feb 4, 2021
Messages
114
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
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.

TIE-IN Welding Log SD 2021 W.xlsx
ABCDEFGHIJ
1Backlog
2PWHTMPI/PTHTRTUT
3Requested1166711005
4Performed76664845
5Backlog407160
6
7ARRAY OF TABLEEXAMPLE ( CAN BE CHANGE AFTER SOME TIME)A2:CC367
8ALL INFO IN ONE LINE EXAMPLEA2:CC2
9PWHT
101A2:CC2A2:CC2A2:CC2A2:CC2A2:CC2A2:CC2A2:CC2A2:CC2and E.T.C
112A15:CC15A15:CC15A15:CC15A15:CC15A15:CC15A15:CC15A15:CC15A15:CC15and E.T.C
123A107:CC107A107:CC107A107:CC107A107:CC107A107:CC107A107:CC107A107:CC107A107:CC107and E.T.C
134A208:CC208A208:CC208A208:CC208A208:CC208A208:CC208A208:CC208A208:CC208A208:CC208and E.T.C
14HT
151
162
173
184
195
206
217
22RT
231
242
253
264
275
286
297
308
319
3210
3311
3412
3513
3614
3715
3816
NDT BackLog
Cell Formulas
RangeFormula
C3C3=COUNTA('Weld log'!BU2:BU1034)
D3D3=COUNTA('Weld log'!BC59:BC1034)
E3E3=COUNTA('Weld log'!BG59:BG1034)
F3F3=COUNTA('Weld log'!BK59:BK1034)
G3G3=COUNTA('Weld log'!BZ59:BZ1034)
C4C4=COUNTA('Weld log'!BV59:BV1034)
D4D4=COUNTA('Weld log'!BD59:BD1034)
E4E4=COUNTA('Weld log'!BH59:BH1034)
F4F4=COUNTA('Weld log'!BL59:BL1034)
G4G4=COUNTA('Weld log'!CA67:CA1034)
C5:G5C5=C3-C4
 
Last edited:

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Forum statistics

Threads
1,224,813
Messages
6,181,118
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top