Menu

1 / 6

Excel has a better way to rank your data without moving a single row

MakeUseOf ·Adaeze Uche·about 13 hours ago
#7K6q60BV
#makeuseof#rank#column#formula#value
Reading 0:00
15s threshold

Picture a sales tracker with sales reps grouped alphabetically by region and deals arranged by their close dates. If someone asked which sales rep was leading in deals closed, the obvious move would be to sort the revenue column in Excel from largest to smallest . You'll have your answer in seconds.

The problem is that the close dates would move too, and the regional groupings would scatter across the sheet. Just to answer one question, you could leave everyone else using the workbook wondering what happened to the layout. Thankfully, Excel has another way to rank the data while leaving every row where it belongs.

Ranking doesn't have to mean rearranging

Let the formula keep score

Sorting changes where values appear on your worksheet, while ranking tells you where each value would be if those records were ordered.…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.