Spreadsheet: 599166d1542884987-need-help-making-countifs-formula-display-as-blank-if-its-criteria-cell-is-blank-excel-list-example
Sheet: Inspection List

Date added | Supplier ID | Part no. / KIT no. | Part name | Source | Date removed | Control code status | Inspection sheet? | Category | IFS Code | Last checked (and decided inspection code should stay the way it is) | Comments | Last NCR? | Consecutive positive inspections | Total negative inspections | Total inspections | Duplicate?
2015-08-11 00:00:00 | 3343 | 508536 | Arm f/tailgate LH machined |  |  | YES |  | A | A | 2018-11-09 00:00:00
2015-08-11 00:00:00 | 3343 | 508542 | Arm f/tailgate RH machined |  |  | YES |  | A | A | 2018-11-09 00:00:00
2015-08-11 00:00:00 | 3343 | 527233 | Arm rhs machined |  |  | YES |  | B | A | 2018-11-12 00:00:00 | NCR 15.02.2017
2015-08-11 00:00:00 | 3209 | 800485 | Cross beam w/cab stopper machined |  |  | YES |  | B | C | 2018-11-12 00:00:00
2015-08-11 00:00:00 | 3702 | 801576 | Exhaust pipe from T-pipe upper |  |  | YES |  | B | A | 2018-11-12 00:00:00
2015-08-11 00:00:00 | 3072 | 528979 | Fender lh DA30 |  |  | 100% control on production line |  | A | None | 2018-11-12 00:00:00
2015-08-11 00:00:00 | 3072 | 528645 | Fender lh DA40 |  |  | 100% control on production line |  | A | None | 2018-11-12 00:00:00
2015-08-11 00:00:00 | 3072 | 528646 | Fender rh DA40 |  |  | 100% control on production line |  | A | None | 2018-11-12 00:00:00
2015-08-11 00:00:00 | 3072 | 802092 | Fuel tank - DA40 (rw) |  |  | YES |  | A | A | 2018-11-12 00:00:00
2015-08-11 00:00:00 | 3751 | 801091 | Housing f/level sensor (Machined) |  |  | YES |  | B | A | 2018-11-19 00:00:00
2015-08-11 00:00:00 | 2250 | 528032 | Pipe f/oil cooler inlet |  |  | YES |  | B | A | 2018-11-12 00:00:00
2015-08-11 00:00:00 | 3508 | 526985 | Tilt cylinder 115/70/2290 Burnside |  |  | 100% control at warehouse by [NAME] |  | B | None | 2018-11-13 00:00:00
2015-08-11 00:00:00 | 3508 | 527924 | [NAME] 125/85/2614 |  |  | 100% control at warehouse by [NAME] |  | B | None | 2018-11-13 00:00:00
2015-08-11 00:00:00 | 3554 | 502112 | Tilt cylinder bracket lh |  |  | YES |  | B | D | 2018-11-14 00:00:00
2015-08-11 00:00:00 | 3554 | 502113 | Tilt cylinder bracket rh |  |  | YES |  | B | D | 2018-11-14 00:00:00
2015-08-11 00:00:00 | 3211 | 513674 | Wheel axle, preturned blank stock |  |  | 100% control by [NAME] |  | A | None | 2018-11-14 00:00:00
2015-09-10 00:00:00 | 3404 | 502123 | Blank f/filter head |  |  | YES |  | B | A | 2018-11-14 00:00:00
2015-10-15 00:00:00 | 3072 | 528980 | Fender R.h |  |  | 100% control on production line |  | A | None | 2018-11-14 00:00:00
2015-11-04 00:00:00 | 3072 | 802709 | Bracket f/step |  |  | YES |  | B | A | 2018-11-14 00:00:00 | Inspect a few more.
2015-11-25 00:00:00 | 3404 | 801186 | Articulation hinge DA40 [NAME] w/tag | NCR 11389 |  | YES |  | B | A | 2018-11-14 00:00:00 | NCR 30.10.18
2015-11-25 00:00:00 | 1150 | 34014047 | [NAME] subassy DA40 T4F | NCR 11215 |  | YES |  | B | D | 2018-11-14 00:00:00
2016-01-27 00:00:00 | 3341 | 803525 | Steering valve | NCR 11419 |  | YES |  | A | A | 2018-11-14 00:00:00
2016-04-22 00:00:00 | 6083 | 808022 | Elbow | ECN-2724 |  | YES |  | B | A | 2018-11-14 00:00:00 | Pressure test!!
2016-06-16 00:00:00 | 3072 | 802818 | Hydraulic tank DA30 ([NAME] lock) | NCR |  | YES |  | A | A | 2018-11-14 00:00:00 | OUTDATED. SPARE PART. | 2018-01-12 00:00:00
2016-08-03 00:00:00 | 3343 | 527231 | Arms lhs machined |  |  | YES |  | B | A | 2018-11-14 00:00:00
2016-08-03 00:00:00 | 1145 | 800436 | Gasket f/front light protection lh |  |  | YES |  | B | A | 2018-11-14 00:00:00 |  | 2018-09-07 00:00:00
2016-08-09 00:00:00 | 3729 | 803630 | Spacer f/bearing inner | NCR 11686 |  | YES |  | B | A | 2018-11-14 00:00:00 |  | 2018-08-31 00:00:00
2016-08-26 00:00:00 | 3072 | 809281 | Base plate f/handle bracket | ECN-2762 |  | YES |  | B | D | 2018-11-14 00:00:00
2016-08-26 00:00:00 | 3072 | 809280 | Driver's seat bracket assembly | ECN-2761 |  | YES |  | B | D | 2018-11-14 00:00:00
2016-08-29 00:00:00 | 2250 | 809190 | Mirror holder | ECN-2752 |  | YES |  | B | A | 2018-11-16 00:00:00
2016-09-15 00:00:00 | 3072 | 809234 | Attachment bar long | ECN-2757 |  | YES |  | B | D | 2018-11-16 00:00:00
2016-09-21 00:00:00 | 2571 | 807351 | Bonnet w/rails DA40 T4F | NCR |  | 100% control by [NAME] |  | A | None | 2018-11-16 00:00:00
2016-09-21 00:00:00 | 3209 | 26004050 | KIT Steel for Rearframe DA40 | NCR |  | YES |  | B | A | 2018-11-16 00:00:00 | 505701 | 2017-04-16 00:00:00
2016-10-18 00:00:00 | 3072 | 800570 | Bracket welded LH | ECN-2736 |  | YES |  | B | D | 2018-11-16 00:00:00
2016-10-18 00:00:00 | 3072 | 808004 | Bracket welded rear | ECN-2736 |  | YES |  | B | D | 2018-11-16 00:00:00
2016-10-18 00:00:00 | 3072 | 800571 | Bracket welded RH | ECN-2736 |  | YES |  | B | D | 2018-11-16 00:00:00
2016-10-18 00:00:00 | 3072 | 807984 | Protection for axle | ECN-2736 |  | YES |  | B | D | 2018-11-16 00:00:00
2016-11-04 00:00:00 | 3329 | 803030 | Seal ring ø443 polyurethane | NCR 11839 |  | YES |  | B | B | 2018-11-16 00:00:00
2016-11-07 00:00:00 | 3349 | 803382 | Radiator DA4 | NCR 11852 |  | YES |  | B | A | 2018-11-16 00:00:00 |  | 2018-09-04 00:00:00
2016-12-14 00:00:00 | 3343 | 808381 | Front frame machined DA40 | ECN-2729 |  | YES |  | A | A (None) | 2018-11-19 00:00:00 | 19.11.18 Added A cat/code. | 2018-11-08 00:00:00
2017-01-06 00:00:00 | 3379 | 507898 | Blank f/articulation hinge (0727) | NCR 11895 |  | YES |  | B | A | 2018-11-19 00:00:00 |  | 2018-01-02 00:00:00
2017-01-06 00:00:00 | 3209 | 529950 | Cross beam front | NCR 11924 |  | YES |  | B | A | 2018-11-19 00:00:00 |  | 2018-02-28 00:00:00
2017-01-06 00:00:00 | 2250 | 808666 | [NAME] f/fender LHS DA40 | NCR 11872 |  | YES |  | B | A | 2018-11-19 00:00:00 |  | 2017-08-31 00:00:00
2017-01-06 00:00:00 | 2250 | 808681 | [NAME] f/fender RHS DA40 | NCR 11873 |  | YES |  | B | A | 2018-11-19 00:00:00 |  | 2017-08-31 00:00:00
2017-01-06 00:00:00 | 2335 | 24003070 | KIT Body DA30 | NCR 11887, 11945 |  | YES |  | B | A | 2018-11-19 00:00:00 | 36207
2017-01-06 00:00:00 | 3072 | 808471 | [NAME] assy | NCR 11925 |  | YES |  | B | A | 2018-11-19 00:00:00
2017-01-06 00:00:00 | 3343 | 802174 | Tilt bracket, body- machined | NCR 11889 |  | YES |  | B | A | 2018-11-19 00:00:00 |  | 2018-08-16 00:00:00
2017-01-12 00:00:00 | 3780 | 26004080 | KIT Steel for Rearframe DA40 | NCR 12446, 12448, 12460, 12479, 12480 |  | YES |  | B | A |  | Part 501243, 802428, 804023, 804022, 529996, 512338. | 2018-09-12 00:00:00
2017-02-21 00:00:00 | 3072 | 808332 | Roadkit cage | NCR 11968 |  | YES |  | B | A | 2018-11-19 00:00:00 | 1 more inspection.. | 2017-09-05 00:00:00
2017-03-22 00:00:00 | 3209 | 808185 | Suspension arm machined lh | NCR 12084 |  | YES |  | B | A | 2018-11-19 00:00:00 |  | 2018-09-28 00:00:00
2017-03-22 00:00:00 | 3209 | 808186 | Suspension arm machined rh | NCR 12084 |  | YES |  | B | A | 2018-11-19 00:00:00 | check RH counterpart of failed part 808185 | 2018-02-05 00:00:00
2017-05-15 00:00:00 | 1150 | 803748 | Suction hose DA30/40 | NCR 12168 |  | YES |  | B | A | 2018-11-19 00:00:00 | (Removed 22.03.2017). Added again | 2018-10-16 00:00:00
2017-05-31 00:00:00 | 3072 | 810403 | Bracket f/Cooling Pipe | NCR 12190 |  | YES |  | B | A |  | OUTDATED? | 2017-05-22 00:00:00
2017-09-08 00:00:00 | 3211 | 802978 | Frame link bolt | NCR 12315 |  | YES |  | B | A | 2018-11-19 00:00:00 |  | 2017-09-08 00:00:00
2017-11-17 00:00:00 | 3751 | 808417 | [NAME] f/idle gear w/lub | S1 |  | YES | YES | B | D | 2018-11-19 00:00:00 |  | 2018-08-23 00:00:00
2017-11-21 00:00:00 | 1019 | 807125 | Cab support | S1 |  | YES | NO | B (C) | D | 2018-11-21 00:00:00 | Changed to B | 2018-06-20 00:00:00
2017-11-21 00:00:00 | 3072 | 811344 | Cross beam machined | S1 |  | YES | NO | B (C) | D | 2018-11-21 00:00:00 | Changed to B | 2018-11-06 00:00:00
2017-11-22 00:00:00 | 3712 | 512181 | Disc carrier cast blank. | NCR 12372 |  | YES |  | B | A | 2018-11-21 00:00:00 | NG. Recent NCR. | 2018-09-17 00:00:00
2017-11-22 00:00:00 | 3209 | 26003087 | KIT Steel for Rearframe DA30 [NAME] | S1 / Production issue |  | YES |  | A | A | 2018-11-21 00:00:00 | No inspections..
2017-11-22 00:00:00 | 3780 | 26003087 | KIT Steel for Rearframe DA30 [NAME] | S1 / Production issue |  | YES |  | A | A | 2018-11-21 00:00:00 | Part 505744
2017-11-22 00:00:00 | 3780 | 26003085 | KIT Steel for Susp.Arms DA30 [NAME] | S1 |  | YES |  | B | A | 2018-11-21 00:00:00
2017-11-22 00:00:00 | 3780 | 26003086 | KIT Steel for Tandemhousing DA30 S1 | S1 |  | YES |  | B | A | 2018-11-21 00:00:00
2017-12-22 00:00:00 | 3209 | 807172 | Bonnet beam [NAME] machined | Dim. dev. |  | YES |  | B | D | 2018-11-21 00:00:00
2017-12-22 00:00:00 | 3712 | 500644 | Frame link bolt machined | ECN-2859 |  | YES |  | A | D | 2018-11-21 00:00:00 | No inspections..
2017-12-22 00:00:00 | 2571 | 810172 | Top hat (orange) Stage 1 | Dim. dev. |  | YES |  | B | C | 2018-11-21 00:00:00
2018-01-15 00:00:00 | 3702 | 529315 | Exhaust T-pipe | NCR 12461 |  | YES |  | B | D (None) | 2018-11-21 00:00:00 | 21.11.18 Added code D. | 2018-01-15 00:00:00
2018-01-19 00:00:00 | 1150 | 36063085 | [NAME] kit o/Link final assy DA30 S1 | ECN-2863 |  | YES |  | C | A |  | Part 534715, 536588. [NAME] ok fjerne? | None
2018-02-05 00:00:00 | 3712 | 810496 | Parking brake br SA10000 Machined | ECN-2857 |  | YES |  | B | A | 2018-11-21 00:00:00 |  | 2017-12-08 00:00:00
2018-02-19 00:00:00 | 3712 | 514997 | Hub housing, cast blank- rear | NCR 12509 |  | YES |  | B | A | 2018-11-21 00:00:00 |  | 2018-10-30 00:00:00
2018-02-27 00:00:00 | 3072 | 802805 | Arm f/handle bracket | NCR 12539 |  | YES |  | B | A | 2018-11-21 00:00:00 |  | 2018-06-21 00:00:00
2018-02-27 00:00:00 | 3072 | 529841 | Draw bar | Production issue |  | YES |  | B | A | 2018-11-21 00:00:00 |  | 2018-10-12 00:00:00
2018-03-02 00:00:00 | 3072 | 811728 | Bracket f/main valve | ECN-2871 |  | YES |  | B (C) | D | 2018-11-21 00:00:00 |  | 2018-01-08 00:00:00
2018-04-05 00:00:00 | 3731 | 535829 | Vent Level Controller | NCR 12493, field claim |  | YES |  | A | A | 2018-11-21 00:00:00 |  | 2018-06-04 00:00:00
2018-04-06 00:00:00 | 3780 | 505744 | Front section, welded | Production issue |  | YES |  | A | A | 2018-11-21 00:00:00 |  | 2018-09-17 00:00:00
2018-05-02 00:00:00 | 3072 | 802567 | Bracket f/catalyst | NCR |  | YES |  | A | A | 2018-11-21 00:00:00 |  | 2018-06-14 00:00:00
2018-05-02 00:00:00 | 3221 | 811137 | Gear wheel stage 2, TK new (z=67) | ECN-2661 |  | YES |  | A | A | 2018-11-21 00:00:00 |  | 2018-09-14 00:00:00
2018-05-09 00:00:00 | 3072 | 812271 | Air Filter Beam DA30 S1 | ECN-2886 |  | YES |  | A | D | 2018-11-21 00:00:00 |  | 2018-05-22 00:00:00
2018-05-14 00:00:00 | 3729 | 519124 | Pin (45 dia) | NCR 12631 |  | YES |  | A | A | 2018-11-21 00:00:00 |  | 2018-07-02 00:00:00
2018-06-12 00:00:00 | 3729 | 803985 | Cab fit bolt rear | Design change |  | YES |  | A | A | 2018-11-21 00:00:00 |  | 2015-03-12 00:00:00
2018-10-02 00:00:00 | 3167 | 534494 | Tilting cylinder bolt DA30/DA40 | NCR 12850 |  | YES |  | A | A | 2018-11-21 00:00:00 |  | 2018-10-02 00:00:00
2018-10-05 00:00:00 | 3784 | 813305 | Suspension arm welded LH | ECN-2912 |  | NO |  | A | None |  | Part no. not yet registered in IFS
2018-10-05 00:00:00 | 3784 | 813306 | Suspension arm welded RH | ECN-2912 |  | NO |  | A | None |  | Part no. not yet registered in IFS
2018-10-11 00:00:00 |  | 811892 | Mirror holder [NAME] | S2 |  | YES |  | B | None |  | Part in IFS.
2018-10-11 00:00:00 |  | 811893 | Mirror holder RH | S2 |  | YES |  | B | None |  | Part in IFS.
2018-10-11 00:00:00 |  | 812090 | [NAME] front LH f/ mudguard DA30 | S2 |  | Only proto order 74713 |  | B |  |  | Part no. not yet registered in IFS
2018-10-11 00:00:00 |  | 812091 | [NAME] rear [NAME] f/ mudguard | S2 |  | Only proto order 74713 |  | B |  |  | Part no. not yet registered in IFS
2018-10-11 00:00:00 |  | 812092 | [NAME] rh f/ mudguard | S2 |  | Only proto order 74713 |  | B |  |  | Part no. not yet registered in IFS
2018-10-11 00:00:00 |  | 812735 | [NAME] lh f/ mudguard | S2 |  | Only proto order 74713 |  | B |  |  | Part no. not yet registered in IFS
2018-10-11 00:00:00 |  | 812736 | [NAME] rh f/ mudguard | S2 |  | Only proto order 74713 |  | B |  |  | Part no. not yet registered in IFS
2018-11-09 00:00:00 | 3783 | 813276 | Articulation hinge DA40 | ECN-2908 |  | YES |  | A
2018-11-09 00:00:00 | 3072 | 813472 | Fuel tank DA30 Welded | S2 |  | YES |  | A
2018-11-09 00:00:00 | 3072 | 812116 | Hydraulic tank | S2 |  | YES |  | A
2018-11-09 00:00:00 |  | 813280 | Fender DA40S2 Welded | S2 |  | NO |  | A |  |  | Part no. not yet registered in IFS
2018-11-09 00:00:00 |  | 813088 | Cover f/Exhaust | S2 |  | NO |  | B |  |  | Part no. not yet registered in IFS
2018-11-09 00:00:00 | 3752 | 811366 | Claw end machined | Production issue |  | YES |  | A
 |  | 813557 | Fuel tank DA40 Welded | S2 |  | NO |  | A |  |  | Part no. not yet registered in IFS
2018-11-09 00:00:00 | 6083 | 813267 | Pipe CAC-Engine DA30 S5 | S2 |  | YES |  | B
2018-11-09 00:00:00 | 3072 | 811495 | Mudguard lh DA30 | S2 |  | YES |  | A
2018-11-09 00:00:00 | 3072 | 811856 | Mudguard rh DA30 | S2 |  | YES |  | A
2018-11-09 00:00:00 | 3072 | 812077 | Mudguard lh DA40 | S2 |  | YES |  | A
2018-11-09 00:00:00 | 3072 | 812078 | Mudguard rh DA40 | S2 |  | YES |  | A
2018-11-09 00:00:00 | 3751 | 813570 | Axle Housing Casted | S2 |  | YES |  | B
2018-11-16 00:00:00 | 2571 | 812112 | [NAME] | S2 |  | YES |  | C
2018-11-19 00:00:00 | 3780 | 508306 | Side plate, outer | NCR 12923 |  | YES |  | B | B | 2018-11-19 00:00:00 |  | 2018-11-07 00:00:00
2018-11-19 00:00:00 | 3209 | 501243 | Foundation plate welded | NCR 12446 |  | YES |  | B | A | 2018-11-19 00:00:00 | Added. Different supplier. | 2018-01-10 00:00:00
2018-11-19 00:00:00 | 3167 | 802978 | Frame link bolt | NCR 12315 | YES | YES |  | B | A | 2018-11-19 00:00:00 | Added. Different supplier. | 2017-09-08 00:00:00
2018-11-19 00:00:00 | 3072 | 32043085 | Kit ESP team 32 DA30 S1 |  |  | YES |  | B | A | 2018-11-19 00:00:00 | Added. Parts were listed, but not KIT.
 |  |  | UPDATE COUNT FORMULA IN LOG IF LIST IS THIS LONG