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 new MINIFS function to 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 fourth 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 how to use the new MINIFS function to find the minimum value based on one or multiple criteria from multiple columns. This solution does NOT require an array formula. We do NOT have to press Ctrl+Shift+Enter when entering the formula in Excel.

This is probably the most simple function to use for our challenge. However, MINIFS was introduced in Excel 2016 and will only be available to users on a later version of Excel 2016. If you are on an Office 365 subscription then you should have the latest version. All users of the file will also have to have the latest version in order for this to work.

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
#3 How to use AGGREGATE for MIN IF Formulas in Excel https://youtu.be/4utkmMTIoXU
#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:48 MINIFS Function
05:12 Conclusion