Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/

In this video you will learn how to use the AGGREGATE function to do a MIN IF calculation in Excel. This formula will find the minimum value in a column based on matching criteria from another column.
Download the file: https://www.excelcampus.com/functions/formula-challenge-first-sale-each-month/

This is the third video in a series on solutions to the Formula Challenge to find the first sales transaction for each month of the year. There were over 100 solutions submitted on the blog page, so I created a series of videos to explain the most popular solutions.

In this video I explain a technique for using the AGGREGATE function to calculate a MIN IF. This solution does NOT require an array formula. We do NOT have to press Ctrl+Shift+Enter when entering the formula in Excel.

We use the SMALL function in AGGREGATE to return the 1st or smallest value. The SMALL function has an optional [k] argument that allows us to return the 2nd, 3rd, etc. smallest value. This makes the formula a bit more flexible than the other solutions.

AGGREGATE was introduced in Excel 2010 for Windows and is available on all versions of Excel for Windows and Mac after 2010. It's similar to the SUBTOTAL function, but provides additional functions and options for handling errors and hidden rows. It's a very versatile function and a great one to know.

In the next video I explain how to use the MINIFS function. For that formula we do NOT need to use the Ctrl+Shift+Enter array formula.

Additional links:
#1 Excel Array Formulas Explained with MIN and IF Functions https://youtu.be/I23Cy8FkMLY
#2 MIN IF Array Formulas with VLOOKUP or INDEX MATCH https://youtu.be/IdVUhCBhjps
#4 How to use MINIFS to Calculate Minimum Value based on Multiple Criteria https://youtu.be/pGvQnCJxEt4
#5 How to Use AGGREGATE for MIN IF Formula with Multiple Criteria https://youtu.be/NJFCd3HimXc

Calendar System & Dates Explained in Excel: https://www.excelcampus.com/functions/how-dates-work-in-excel/
Beginner's Guide to Excel Tables: https://www.excelcampus.com/tables/excel-tables-tutorial-video/
How to Turn Table Formulas On/Off: https://www.excelcampus.com/library/turn-off-structured-references-table-formulas/
00:00 Introduction
00:49 Aggregate Function
09:14 Outro