Have been puzzling about the below quite a while. Hope someone can help me out on this.
Column A contains days, multiple rows per day
Column B contains hours, multiple rows per day
I'd like to select/filter the 'earliest' hour (first entry) of each day.
How to filter those?
Example below.
-day time
<colgroup><col><col></colgroup><tbody>
</tbody>
-etc-
Thanks.
=
Column A contains days, multiple rows per day
Column B contains hours, multiple rows per day
I'd like to select/filter the 'earliest' hour (first entry) of each day.
How to filter those?
Example below.
-day time
08-12-2016 | 09:21:06 |
08-12-2016 | 09:20:49 |
08-12-2016 | 05:10:06 |
07-12-2016 | 16:47:42 |
07-12-2016 | 16:44:40 |
07-12-2016 | 16:44:25 |
07-12-2016 | 08:15:55 |
07-12-2016 | 08:15:55 |
07-12-2016 | 08:15:55 |
07-12-2016 | 08:15:55 |
07-12-2016 | 05:08:23 |
06-12-2016 | 16:46:59 |
06-12-2016 | 16:41:04 |
06-12-2016 | 16:40:48 |
06-12-2016 | 04:20:05 |
05-12-2016 | 17:14:36 |
<colgroup><col><col></colgroup><tbody>
</tbody>
-etc-
Thanks.
=