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

Actually my version of Excel doesn't support the new functions.

1.Syntax of UNIQUE Function :- =UNIQUE(array, [by_col], [exactly_once])

[by_col], [exactly_once]-optional

2.Syntax of SORT Function :-=SORT(array,[sort_index],[sort_order],[by_col])

[sort_index],[sort_order],[by_col]-optional

The Excel file link is :-

https://docs.google.com/spreadsheets/d/1HGGmzm4BCEWUKOInkSRP7NmVZ0-csJro/edit?usp=share_link&ouid=104511697641380266975&rtpof=true&sd=true

The project was completed and the concepts are covered in the later half of the course. This helped me to understand and recall concepts of Excel.