Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro smallest/highest record
Hi, i need a macro to keep the smallest and highest record.
Ex: date door time name dep1 dep 2 01.05.2009 in 07:52:51 A.D. 01.05.2009 out 16:33:27 A.D. 01.05.2009 in 16:33:37 A.D. 01.05.2009 out 21:00:04 A.D 02.05.2009 in 07:45:01 A.D. 02.05.2009 in 08:22:14 A.D. 02.05.2009 in 16:04:10 A.D. 02.05.2009 out 20:59:09 A.D. I need the macro to keep only this: 01.05.2009 in 07:52:51 A.D. 01.05.2009 out 21:00:04 A.D 02.05.2009 in 07:45:01 A.D. 02.05.2009 out 20:59:09 A.D. The names are not in order, only the date and time. And i have about 100 names. Another thing is that one person can have only one "out" and 3 "in", or just one ("in"or "out"). All i need is to keep the smallest row with "in" and highest row with "out", by looking first at the date, then time, then name and then at door. Can this be done? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Record Macro and Edit Macro options disabled | New Users to Excel | |||
Find Highest Value for Each Record | Excel Discussion (Misc queries) | |||
How do I record new Highest / Lowest numbers as data changes in ce | Excel Discussion (Misc queries) | |||
What does it mean to record the macro | Excel Discussion (Misc queries) | |||
Record New Macro | Setting up and Configuration of Excel |