Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 200
Default Delete Duplicate rows

MarkM wrote:
Does anyone have some basic code that will check for and delete duplicate rows?

I have a list of items number, which is sorted, coming form a customer sales
history file and need to remove the rows with duplicate rows. The item
numbers in column C.

Thanks for you help.

You need to be a little more precise in your description.

Assume you have duplicated values in Column C. Do you want to delete all
those rows? Or only the duplicated rows? Or only the duplicated values?
Or only the cells with duplicated values?

Alan Beban
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
delete duplicate rows, keep one Wasdell Excel Discussion (Misc queries) 1 October 30th 09 12:16 PM
delete duplicate rows christinaLO Excel Worksheet Functions 1 February 27th 07 06:22 PM
Delete Duplicate rows KC Rippstein Excel Programming 0 December 22nd 06 08:15 PM
Delete duplicate rows Lupe Excel Programming 1 September 12th 06 03:11 PM
delete duplicate rows rhys Excel Programming 2 July 29th 03 12:52 PM


All times are GMT +1. The time now is 09:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"