How do I get rid of duplicate rows?

[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?

 

[Eduardo]

Hi,
Look into CPearson web go to the middle of the page

http://www.cpearson.com/excel/deleting.htm

if this helps please click yes, thanks

 

[Luke M]

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.

 

[Chip]

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.

 

[Luke M]

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)

 

[Gord Dibben]

Data>Filter>Advanced.

See how to filter for Unique Records only

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


Gord Dibben MS Excel MVP