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?

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

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

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


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

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.

"Eduardo" wrote:

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

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

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)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Chip" wrote:

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.

"Eduardo" wrote:

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

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

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?