Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
We have a security log that tracks, on a daily basis, each time a user enters
our office suite using their security badge. What we are looking for is a way to remove all the rows from this spreadsheet except for the rows which contain the first and last time per day the user accessed a badge reader. Here is some example data: Admitted 10/17/2007 12:23 Entered 10/17/2007 12:23 Admitted 10/17/2007 14:37 Entered 10/17/2007 14:37 Admitted 10/17/2007 16:55 Entered 10/17/2007 16:55 Admitted 10/17/2007 18:31 Admitted 10/18/2007 10:13 Entered 10/18/2007 10:13 Admitted 10/18/2007 14:11 Entered 10/18/2007 14:11 Admitted 10/18/2007 17:39 Entered 10/18/2007 17:39 Admitted 10/18/2007 17:43 Entered 10/18/2007 17:43 Admitted 10/19/2007 10:46 Entered 10/19/2007 10:46 Admitted 10/19/2007 16:39 Entered 10/19/2007 16:39 Admitted 10/19/2007 18:40 Entered 10/19/2007 18:40 Admitted 10/19/2007 21:13 Admitted 10/22/2007 10:33 Entered 10/22/2007 10:33 Admitted 10/22/2007 13:17 Entered 10/22/2007 13:17 Admitted 10/22/2007 14:03 Entered 10/22/2007 14:03 Admitted 10/22/2007 15:58 Entered 10/22/2007 15:58 Admitted 10/22/2007 18:51 What we wouuld like to get in the end would be: Admitted 10/17/2007 12:23 Admitted 10/17/2007 18:31 Entered 10/18/2007 10:13 Entered 10/18/2007 17:43 Admitted 10/19/2007 10:46 Admitted 10/19/2007 21:13 Entered 10/22/2007 10:33 Admitted 10/22/2007 18:51 Thanks very much! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to Delete rows on a criteria | Excel Programming | |||
Delete rows based on certain criteria | Excel Discussion (Misc queries) | |||
Delete rows with different criteria | Excel Programming | |||
delete rows with criteria | Excel Programming | |||
Delete rows w/o criteria | Excel Programming |