I have a column for serial numbers and a pass/fail column.
I have created an additional column from the serial number column that gives me a list of the unique serial numbers contained with in the original serial number column.
What I would like to do now is:
1) Take all the pass/fail data and summarize it with two more columns next to the newly created unique serial number columns called Pass and another one called Failed.
a) In the pass column I would like to total the number of times the unique serial number passed the test.
b) In the failed column I would like to total the number of times the unique serial number failed the test.
Thanks for any help.
PS If I have not made my self clear, please let me know and I will clarify.
