I'm trying to create a spreadsheet that ranks employees based on certain metrics. In this case it's quality. In the attached workbook, I receive it sorted by employee then month. I want to use the RANK() function to rank each employee based on their quality score (column D) for the month. This list will grown and shrink, from month to month, so I can't hardcode a range in.
Let me know if you need more information.
Rank Values Based on Criteria.xlsx
Bookmarks