Solution to Challenge-15| Excel 365 Dynamic Array Formulas | LET| FILTER TEXT|XMATCH|XLOOKUP|CHOOSE

Solution to Fifteenth (15th) Challenge with Excel 365 Dynamic Array Formulas

In this video, I demonstrate how to find the highest and lowest sales for a selected salesperson and day using a single dynamic formula in Excel.

This solution uses LET, FILTER, TEXT, XMATCH, XLOOKUP, and CHOOSE to return results like

"Highest Sales-297185 (4th Tuesday)
Lowest Sales-288731 (3rd Tuesday)"

Perfect for learning advanced Excel formulas and dynamic reporting with Excel 365.

📌 Try the formula, change the dropdowns, and see the magic happen!

Download Excel File:
https://1drv.ms/x/c/F66A2644F1B4537C/IQDMxl4-83-rQIJ4u_ocYzvzARxVR19tCfHlFm-duqMvf6I?e=HBrFqt

LinkedIn Post:
https://lnkd.in/g5D7W8HP

Download Free eBook:
https://www.shahalamanalytics.com/newsletter/ebook/

The next will be Solution to Fifteenth (15th) Challenge with Excel Power Query M Code

I appreciate your understanding of any mistakes I made—please focus on learning and enjoy the video.

Please follow our Social Media:
https://www.linkedin.com/in/shahalam-analytics-excelbi/
https://www.facebook.com/ShahAlamDataTrainingAnalytics/
https://www.shahalamanalytics.com/

@ShahAlamAnalytics | Md Shah Alam | Microsoft Certified Trainer | Excel | Power BI

Видео Solution to Challenge-15| Excel 365 Dynamic Array Formulas | LET| FILTER TEXT|XMATCH|XLOOKUP|CHOOSE канала Md. Shah Alam