RANK | CSE 148 – Excel Exam 1

Still feeling nervous for your exam? Check out the Excel Cram Kit (Exam 1) for practice modules that emulate the difficulty that you'll face on your exam. Each module includes a thorough step-by-step explanation where I walk you through the entire problem solving process!

RANK explained

Imagine that we're the announcer at a high school track meet, and the runners are currently competing in the 1500m race.

Our job is to take their times, and then rank them from lowest to highest.

To do this, we can use the RANK function on each runner's time!

The RANK function enables us to easily see where a value ranks within a list.

Coding a RANK

Given the above track meet example, let's say that each runner scores the following times:

Let's start by ranking the first runner. To do so, we'll use the following template:

=RANK(value, range, [order])

In our case, the first value will be cell B2, since that's where Michael's time is stored.

=RANK(B2, range, [order])

Next, for the range. This represents the cells contain all the values to be ranked. In this case, that's cells B2:B6.

=RANK(B2, B2:B6, [order])

We can leave [order] blank for now because...

Arguments in [ ] are not required.

When we plug this RANK function into our spreadsheet, we get the following result:

Somethings wrong here... why did Michael get ranked 4th but had the 2nd best time?

The reason is because our RANK function (by default) ranks in descending order (meaning the highest values get the top rankings). Since we're dealing with a race, we want the lowest values to get the top rankings, so we must specify we're ranking in ascending order.

To do so, we need to place a "1" in the [order] argument of our RANK function.

=RANK(B2, B2:B6, 1)

The [order] argument enables us to rank in descending order (value of 0, is default) or ascending order (value of 1).

Notice now that Michael is properly ranked in 2nd place!

Now, what about the rest of the runners? To get their ranks, we must first specify an absolute cell reference for our range.

=RANK(B2, $B$2:$B$6, 1)

After doing so, all we need to do is copy the formula for Michael's ranking down to all the runners like so!

Practice Problem

Given the following results of a hotdog eating content, determine where Peter ranked!

=RANK(B4, B2:B7)

Note: We didn't place anything for the [order] argument because the default for [order] is descending order, which is what we're going for. If we wanted ascending order, we'd place "1" here.

Excel (Exam 1) Follow-along Guide

It's no secret you retain info better when you write it down. That's why I created the Excel (Exam 1) Follow-along Guide for you!

As you come upon key concepts highlighted in yellow, like this sentence here, you can fill-in-the-blanks on your Follow-along Guide so that you remember all the important stuff for later!

You can obtain the Excel (Exam 1) Follow-along Guide for FREE by entering your email below!

Next, let's learn how to use the COUNT function!

Free Resources

Each exam concept broken down in simple, real-world examples!

ToolsExcel (Exam 1) Follow-along Guide
LessonSUM & AutoSUM
LessonRelative vs. Absolute Cell References
LessonPercent change
LessonExcel charts
LessonImporting text files

Practice Problems

Step-by-step walkthrough for each of the questions you need to be ready for!

"I bought this Cram Kit the night before my exam, and it helped me tremendously. It provides step-by-step explanations for all the units covered in class."

Matt Lamanna
Oct. 24, 2021

Rating: 5 out of 5.

Leave a Comment