G
Guest
I have a spreadsheet that I need a macro for that will go through the
spreadsheet and delete lines that are nearly duplicate. For example, column
A will be a date, and column B an item. If there are two rows that have
identical column Bs (items), I need to delete the oldest row based on the
date in Column A. And then do this for the entire spreadsheet. Please see
example below. Is this possible?
Any help is greatly appreciated. Thank You!
Date Description
10/1/2006 AAX1
1/15/2007 AAX1
Would want to delete the row with the date of 10/1/2006.
spreadsheet and delete lines that are nearly duplicate. For example, column
A will be a date, and column B an item. If there are two rows that have
identical column Bs (items), I need to delete the oldest row based on the
date in Column A. And then do this for the entire spreadsheet. Please see
example below. Is this possible?
Any help is greatly appreciated. Thank You!
Date Description
10/1/2006 AAX1
1/15/2007 AAX1
Would want to delete the row with the date of 10/1/2006.