Excel - Excel Formula To Find The Earliest And Latest Date - Duel 176.5 - Episode 1969.5

2,276 views · Published 13 February 2016 · 8:00 · Indexed 28 October 2026

Channel: MrExcel.com · 2016 · Education

Watch on YouTube

Microsoft Excel Tutorial: Find First and Last in Excel

Welcome back to another episode of Dueling Excel, where Mike Girvin from Excel Is Fun and I, Bill Jelen from MrExcel, go head to head to find the best solution to a common Excel problem. In this episode, we tackle the challenge of finding the earliest and latest times for non-zero events on a given day.

After receiving some great suggestions from our viewers, we decided to explore three different methods for solving this problem. First, we demonstrate how to use a pivot table to quickly and easily find the start and end times. Then, Mike introduces the AGGREGATE function, a powerful tool for performing array operations, to achieve the same result with just one formula. Finally, we take advantage of the new MINIFS and MAXIFS functions in Excel 365 to simplify the process even further.

As always, we encourage our viewers to share their own solutions and ideas in the comments section. It's amazing to see the variety of approaches that can be taken to solve a single problem in Excel. And with the constant updates and new features being added to the program, there's always something new to learn and explore.

So join us for another exciting episode of Dueling Excel, and let us know which method you prefer for finding the first and last non-zero events on a given day. And don't forget to subscribe to our channel for more helpful Excel tips and tricks. Thanks for watching, and we'll see you next time!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/

Table of Contents:
(00:00) Find Earliest & Latest Times in Excel
(00:32) Using a Pivot Table to find the earliest and latest times
(02:25) Dynamic solution using the MIN and MAX functions
(03:28) Using the AGGREGATE function for array operations
(05:35) Formula to compare to previous row
(06:41) New MINIFS and MAXIFS functions in Excel 365
(07:30) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial #excelformula #excelformulasandfunctions #excelnew


This video answers these common search terms:
excel formula to find the earliest date
how to get latest date in excel
excel formula to find the latest date
how to use an aggregate formula in excel
how to use minifs function in excel
how to do maxifs excel


This is a follow up to yesterday's Duel 176 - with four new ways to solve the problem: Pivot table, AGGREGATE, Array Formula, MINIFS.

Join the MrExcel Message Board discussion about this video at  https://www.mrexcel.com/board/threads/1153797/

More from this channel