I have a complex question and am hoping that somebody stuck at home will be able to help.
I have a process where parts may be tested and fail, a repair attempted and the part retested, possibly on more than one occasion until such time as the part has satisfactorily passed final inspection.
Although there is a lot of other information, the table contains the following basics which cannot be changed.
Date Serial No Result
21/03/2018 ABC10001 FAIL
21/03/2018 ABC10002 FAIL
21/03/2018 ABC10002 PASS
22/03/2018 ABC10001 PASS
23/03/2018 ABC10002 FAIL
The list has two serial numbers (there would be thousands) inspected on multiple dates sometimes passing and sometimes failing. I am trying to count and list all individual serial numbers that have failed the last test carried out on them.
In the example ABC10001 failed and then passed so is OK, I want to identify ABC10002 which failed, then passed but was then tested again and failed so effectively I want to list unique serial numbers where the most recent inspection record for that unique serial number was a failure and count how many instance there are.
Any ideas would be greatly appreciated.
I have a process where parts may be tested and fail, a repair attempted and the part retested, possibly on more than one occasion until such time as the part has satisfactorily passed final inspection.
Although there is a lot of other information, the table contains the following basics which cannot be changed.
Date Serial No Result
21/03/2018 ABC10001 FAIL
21/03/2018 ABC10002 FAIL
21/03/2018 ABC10002 PASS
22/03/2018 ABC10001 PASS
23/03/2018 ABC10002 FAIL
The list has two serial numbers (there would be thousands) inspected on multiple dates sometimes passing and sometimes failing. I am trying to count and list all individual serial numbers that have failed the last test carried out on them.
In the example ABC10001 failed and then passed so is OK, I want to identify ABC10002 which failed, then passed but was then tested again and failed so effectively I want to list unique serial numbers where the most recent inspection record for that unique serial number was a failure and count how many instance there are.
Any ideas would be greatly appreciated.
Last edited: