Thread: How do I get rid of duplicate rows?
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default How do I get rid of duplicate rows?
DataFilterAdvanced.

See how to filter for Unique Records only

http://www.contextures.on.ca/xladvfi....html#FilterUR


Gord Dibben MS Excel MVP

On Tue, 18 Aug 2009 06:20:02 -0700, Chip
wrote:

I have a large spreadsheet. My products SKU #'s are in column A. There are
many duplicates for the same SKU#. Matching the rest of the row is not
necessary; I just want to get rid of the duplicate SKU #'s. Any help?

Reply With QuoteReply With Quote