| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete rows based on multiple criteria
Hi, i need a macro to delete rows if multiple criteria are met.
If A1,B1,C1 criteria are met, then the code to delete all rows except the smallest hour. Criteria: A B C D Date Name Door Hour 01.07.2009 JOHN IN 08:00:05 01.07.2009 JOHN IN 08:25:14 The first three criteria must be the same but i need the smallest our to remain. (08:00:05) Can this be done? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete Rows based on criteria in excel | Excel Discussion (Misc queries) | |||
| How can I delete rows programmatically based on certain criteria? | New Users to Excel | |||
| How can I delete rows programmatically based on certain criteria? | Excel Worksheet Functions | |||
| Delete rows based on criteria | Excel Discussion (Misc queries) | |||
| Delete rows based on certain criteria | Excel Discussion (Misc queries) | |||
Threaded Mode
