| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro help
Hi, i need a macro to delete all rows except for the smallest and biggest
time in column "B". But i need the code to look in other columns before that. Some kind of macro criteria. Ex: A B C D E Date Time Station Id Name 01.12.09 08:01:19 IN 5 John 01.12.09 09:05:30 IN 5 John 01.12.09 14:30:58 out 5 John 01.12.09 16:30:19 out 5 John 01.12.09 07:59:23 IN 5 Mary 01.12.09 11:54:20 IN 5 Mary 01.12.09 16:29:13 out 5 Mary 01.12.09 16:34:29 out 5 Mary 02.12.09.... 03.12.09.... This is an example for one day (01.12.2009). All days are consecutive. I need the macro to look first at the "Date", then at "Name", then at the "Station", then at "Time". I need the smallest "IN" time and the biggest "out" time. Result after macro: 01.12.09 08:01:19 IN 5 John 01.12.09 16:30:19 out 5 John 01.12.09 07:59:23 IN 5 Mary 01.12.09 16:34:29 out 5 Mary Can this be done? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
| Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
| My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
| using a cell value to control a counter inside a macro and displaying macro value | Excel Worksheet Functions | |||
| Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
Threaded Mode
