Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies

Excel Project 2 Submission!

Excel Project 2 Google Drive Link!

https://drive.google.com/file/d/1LV1XIi30csGaVlUOddGBC7xtXw0oNyT_/view?usp=drive_link

Data Summary of All Female Client’s for Income and Loan Amount using New Functions (hint: use unique,sort,filter functions) if These functions are not supporting in your software please give a theoritical answer.

As Unique, Sort and Filter Function are not available in my software, I'll write the code theoretically in this text box:

FOR AMT_INCOME_TOTAL COLUMN (INCOME):

=SORT(UNIQUE(FILTER(B2:B307512, A2:A307512 = "F")))

FOR AMT_CREDIT COLUMN (LOAN):

=SORT(UNIQUE(FILTER(C2:C307512, A2:A307512 = "F")))

For Macro Question1 please refer Macros and for Visual Basics for VBA codes!