View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fuzzy Fuzzy is offline
external usenet poster
 
Posts: 35
Default select only non-matching rows

I have a sheet with over 58,000 rows of info. Only some rows are duplicates.
i need to remove just the duplicate rows, leaving only one row of any
duplicate data. i.e rows 56 & 57 are the same - leave only row 56. Anybody
know a script to do this??

Thanks, Stacy