Deleting Rows based on hierarcy

=?Utf-8?B?aGVyZ2Vua2w=?=

Guest

Posts: n/a

26th Jun 2007

Bear with me - new to macros so I am not sure if this can even be done. I
have a spreadsheet of information (15k rows) and there are numerous rows
where all the info is the same except ithe date in one column is different. I
would like to write a macro that looks at the rows of exact duplicates except
for the date and deletes the row that has the lower date keeping the most
recent valued row. Is this possible?

« Saving emails sent by Lotus Notes through Excel | If statement and exit macro »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Deleting Rows based on a Value	Max2073	Microsoft Excel Worksheet Functions	1	14th Aug 2009 01:32 PM
Deleting Rows Based on Criteria	bgoode	Microsoft Access Macros	1	24th Apr 2008 04:33 PM
Deleting rows based upon the value in column D	=?Utf-8?B?U2Vhbg==?=	Microsoft Excel Programming	2	25th Oct 2004 08:59 PM
Deleting rows based on font	Yarroll	Microsoft Excel Misc	3	13th Apr 2004 12:36 PM
Deleting rows based on criteria	John Walker	Microsoft Excel Programming	2	12th Dec 2003 08:37 PM