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

In this video you will learn how array formulas work in Excel and how to calculate the Minimum of one column based on criteria from another column.
Download the file: https://www.excelcampus.com/functions/formula-challenge-first-sale-each-month/

This is the first 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.

The most popular solution was to use a MIN IF array formula. This first video explains how array formulas work with a simple example.

I also explain how to enter the array formula with Ctrl+Shift+Enter. We then use the Evaluate Formula window to step through each part of the formula and learn how Excel calculates arrays.

In the next video I explain how to combine the MIN IF with VLOOKUP or INDEX MATCH functions, to return a matching result from another column.

We will also look at NON-array solutions withe AGGREGATE and MINIFS functions in future videos.

Additional links:

#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
#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:25 Find the First Transaction for Each Month
02:35 Array Formulas Explained
05:46 Bonus – AGGREGATE with Multiple Criteria