Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Deleting Rows based on a Value | Excel Worksheet Functions | |||
Deleting rows based on a cell value | Excel Programming | |||
Deleting rows based on IF statement | Excel Discussion (Misc queries) | |||
Deleting rows based on a cell value | Excel Worksheet Functions | |||
Deleting rows based upon the value in column D | Excel Programming |