Use of Sequence function to create a dynamic calendar template
Download Excel Template from
https://bi-analytics.org/files/file/313-dynamic-calendar-excel-template/
Download file
https://bi-analytics.org/files/file/312-rank-function-in-excel/
The Excel RANK.AVG function returns the rank of a number against a list of other other numeric values. When values contain duplicates, the RANK.AVG function will assign an average rank to each set of duplicates.
The Excel RANK.EQ function returns the rank of a number against a list of other other numeric values. When values contain duplicates, RANK.EQ will assign the higher rank to each set of du