Published On Mar 22, 2018
Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint...
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...
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 • MIN IF Array Formulas with VLOOKUP or...
#3 How to use AGGREGATE for MIN IF Formulas in Excel • How to use AGGREGATE for MIN IF Formu...
#4 How to use MINIFS to Calculate Minimum Value based on Multiple Criteria • How to use MINIFS to Calculate Minimu...
#5 How to Use AGGREGATE for MIN IF Formula with Multiple Criteria • How to Use AGGREGATE for MIN IF Formu...
Calendar System & Dates Explained in Excel: https://www.excelcampus.com/functions...
Beginner's Guide to Excel Tables: https://www.excelcampus.com/tables/ex...
How to Turn Table Formulas On/Off: https://www.excelcampus.com/library/t...
00:00 Introduction
00:25 Find the First Transaction for Each Month
02:35 Array Formulas Explained
05:46 Bonus – AGGREGATE with Multiple Criteria