Find the MAXIMUM value using MAXIFS with DYNAMIC ARRAYS in Excel

Use MAXIFS to find the highest value based on conditions. This video shows you how to find the maximum value using dynamic arrays.

Dynamic arrays work with Excel 365. Microsoft added them to one time licenses from Excel 2021.

✅ Subscribe to our Channel to level up your Excel skills faster

⬇️ Download the file used in the video

▶️ For a detailed explanation of MAXIFS, please see our full video

💻 Courses offered by us

Learn more about our Excel Masterclass course

Explore all courses

📘 Download our E-Book on Excel Shortcuts (Windows and Mac)

🗂️ Access all our templates and E-Books

🤝 Connect with us