How do I get rid of duplicate rows?

  • Thread starter Thread starter Chip
  • Start date Start date
C

Chip

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?
 
In a helper column, input this formula and drag down:

=IF(COUNTIF(A2,$A$2:A2)>1,"DELETE","")

Then do an autofilter on this column for DELETE, and delete those rows.
 
I search Microsoft last night and saw your page. I am not sophisticated to
understand what to do, as I have never used macros. But thanks for your
tireless work to get one.
 
From the workbook, press Alt+F11 to bring up the Visual Basic Editor (VBE).
In the VBE, goto Insert - Module. Paste the coding in from the webside. Close
out the VBE.

Back in your workbook, you can go to Tools-Macro-Macros, and then play a
macro. (shortcut key is Alt+F8)
 
Back
Top