Most valuable professional
  • Hot Topics

Excel Every first time of the day

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 8/12/2016 8/12/2016 8/12/2016 7/12/2016 7/12/2016 7/12/2016 7/12/2016 7/12/2016 7/12/2016 7/12/2016 7/12/2016 6/12/2016 6/12/2016 6/12/2016 6/12/2016 5/12/2016

This question generated 13 answers. To proceed to the answers, click here.

This thread is current as of March 15, 2017.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel