Do you have MS Access?

Import the file into Access, then create & save a 2-column query that simply
retrieves the serial #s and COUNTS the serial #s. Call the query Freq

Now create a new query that uses both the imported table and the Freq query.
Join on serial #. Include ALL the columns from the table and the Count
column from the Freq query. Put a criteria in the Count column of 1. Run
the query

"jamalin" wrote:

I have a 55k line item spreadsheet and want to search thru it to find
duplicate seriel #'s and once found populate a new spreadsheet with only the
duplicates.