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

Jamalin

To list all the duplicates use this formula:

=IF(COUNTIF($A$1:$A$55,$A2)1,$A2,"")

to list unique duplicates use
=IF(AND(COUNTIF($A$1:$A$55,A2)1,COUNTIF($E$1:E1,$ A2)<1),$A2,"")

and copy down, then paste Special values into a new workbook

Regards
Peter