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

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.

Ans: =UNIQUE(array, [by_col], [exactly_once])

=UNIQUE(A2:DR307512)

=FILTER(array, include, [if_empty])

	I
1	F

=FILTER(A2:DR307512,D2:D307512= I1)

=SORT(array, [sort_index], [sort_order], [by_col])

=SORT(A2:DR307512,2,-1)

https://drive.google.com/file/d/1V0dxsm5XtlSxTdBWn0xVLPDKz20nZB-k/view?usp=sharing