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
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
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920