Excel Array Formulas Explained with MIN and IF Functions (Part 1 of 5)
Excel Campus - Jon
@excelcampusAbout
Excel Campus is here to help you learn Excel and save you time with your everyday tasks. My name is Jon Acampora and my goal is to help you improve your Excel skills. This channel contains "how-to" tutorial style videos on a wide range of Excel topics including: formulas, pivot tables, macros, VBA, charts, dashboards, Power Query, Power Pivot, Power BI, and much more. I want to hear from you and learn about what you are struggling with in Excel. Please visit my website and subscribe to my free email newsletter. http://www.excelcampus.com/newsletter/ And don't forget to subscribe to our YouTube channel. Thank you!
Latest Posts
Video Description
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
You May Also Like
Pizza Night Essentials
AI-recommended products based on this video
Beef Tallow and Honey Balm for Skin: Whipped Grass Fed Beef Tallow Balm Moisturizer with Raw Honey and Olive Oil for Face and Body - Natural Cow Fat Cream Unscented
