Time Between Starting College & Taking 1st Geology Class - 6 Methods

Time Between Starting College & Taking 1st Geology Class - 6 Methods

Learn six different methods to calculate the time between starting college and taking the first geology class in Excel. Explore solutions using MIN, MAX, IF, SEARCH functions, INDEX and MATCH with LEFT, AGGREGATE with ISNUMBER and SEARCH, MAXIFS and MINIFS, PivotTables with formulas, and Power Query. Discover techniques applicable to various Excel versions, from older releases to the latest Excel 2016 and beyond. Download the provided start and finished Excel files to follow along with the 27-minute tutorial.