Excel Functions | FILTER & XLOOKUP For Approximate Match | Search Price & Discount in Changing Lists

#excel #excelfunction
--------------------------------------------------------------------
Visit the website for more content: www.aaa-power.net
--------------------------------------------------------------------
Content:
0:00 Intro
1:20 reveiw the example
3:30 FILTER+ CHOOSEROWS
10:06 SUMIFS
12:20 XLOOKUP
15:34 Revenue Calculation
17:29 Close
--------------------------------------------------------------------
To download the excel files:
drive.google.com/drive/folder...
--------------------------------------------------------------------
To subscribe:
/ @aaaexcelenglish
---------------------------------------------------------------------
To follow on Facebook:
/ excelispower
---------------------------------------------------------------------
To follow on LinkedIn:
/ amratef

[@radekminarik7417]

Very nice video again 👍. Thank you for sharing.

[@aaaexcelenglish]

Most welcome 🙏

[@usmaniqbal1836]

Perfect 👍

[@aaaexcelenglish]

Thank you 🙏

[@kebincui]

👍🌹

[@aaaexcelenglish]

Thank you 🙏

[@Bhavik_Khatri]

In my professional opinion, PQ appears to be the more suitable choice, as I do not have access to Office 365 on my personal laptop. I appreciate the video demonstration.

[@aaaexcelenglish]

I do agree that PQ would be much useful in case of large size of data a coplextity of sources and transformation required. In some cases, if the data is too simple in size and complexity, I quick worksheet formula will do the job. Appriciate your contribution and watching the video