Excel Array Formulas Explained with MIN and IF Functions (Part 1 of 5)
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/
Видео Excel Array Formulas Explained with MIN and IF Functions (Part 1 of 5) канала Excel Campus - Jon
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/
Видео Excel Array Formulas Explained with MIN and IF Functions (Part 1 of 5) канала Excel Campus - Jon
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Excel Dynamic Arrays (How they will change EVERYTHING!)How to use Excel Index Match (the right way)Ctrl + Shift + Enter: Excel Array Formulas #01: Review Formula Basics (15 Important Examples)Google Sheets ARRAYFORMULA, Introductions to Arrays, ARRAY_CONSTRAIN, SORT Functions TutorialDynamic Array Formulas in Excel - 8 Things You Need to KnowExcel Array Formula: Count Rows with OR condition - SUMPRODUCT & FREQUENCY Functions (Part 1/3)INDEX MATCH Explained (An Alternative to VLOOKUP)How to use AGGREGATE for MIN IF Formulas in Excel (Part 3 of 5)7 Ways to Use Vlookup in Excel21 New Excel Features from 2021Comprehensive Excel Dynamic Array Formula Lesson: The Power of Array Formulas (EMT 1516)🤖 Excel Macros & VBA - Tutorial for BeginnersDynamic arrays in Excel | Understanding the biggest change to Excel.... ever | Excel Off The GridLearn Macros in 7 Minutes (Microsoft Excel)Return Multiple Match Results in Excel (2 methods)What is an Array Formula in Excel??? - TutorialMIN IF Array Formulas with VLOOKUP or INDEX MATCH (Part 2 of 5)Excel SUMIFS (better version of SUMIF), COUNTIFS & AVERAGEIFS (Multiple Criteria)Excel Array Formula: Mastering Excel Array Formulas | Max | Large | LEN Array Function Hindi