Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies
Unique, sort & filter functions are not working in my Excel, hence writting the syntax below.
1. Filter
Filter(D2:D307512="F")
Eg. The above result set is Stored in Sheet2 A1
2. Unique
UNIQUE(A1)
Eg. The above result set is Stored in Sheet2 B1
3. Sort
Sort(B1)
----------
* Data Summary of All male Client’s for Income and Loan Amount using list Functions (hint:use dsum,daverage,..)
Ans: Check sheet 1.
----------
Attached screenshots of the project done.