Hi guys,
Not sure if it's nice to start straight away with a request, but If you guys can help I would appreciate.
I need a macro that will delete all rows corresponding to Person1 ( or 2, or 3, etc ) except the first one and last one of each day.
For example, in the table below, the first entry of Person1 in 10/3/2017 is at 03:37:31 and the last entry for that day at is 07:30:00. I need to delete all other rows between the first entry and last entry, for each day, based on the Person.
Date Time Name 10/3/2017 03:37:31 Person1 10/3/2017 04:50:10 Person1 10/3/2017 07:30:00 Person1 10/4/2017 01:30:00 Person1 10/4/2017 03:00:00 Person1 10/4/2017 07:30:10 Person1 10/3/2017 01:00:30 Person2 10/3/2017 03:30:15 Person2 10/3/2017 05:15:30 Person2 10/4/2017 01:30:15 Person2 10/4/2017 03:10:00 Person2 10/4/2017 07:30:00 Person2
Please help,
Thank you
Bookmarks