View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Billy Liddel Billy Liddel is offline
external usenet poster
 
Posts: 527
Default create a macro to search an excel spread for duplicates

Oops

I entered the second formula in E2

Peter

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