need help creating a summary from two columns of data in an excel file

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 o...