If you want to learn more about different ways of Ranking numbers in Excel please click on the link below
[ Ссылка ] you have different sets of numbers and consider them as different groups and you want to rank the numbers with in each group you can use either SUM or SUMPRODUCT or COUNTIFS functions. This video explains in detail how you can rank numbers in each group using the above functions.
To download practice Excel file please click on the link below
[ Ссылка ]
