From the course: Google Sheets: Advanced Formulas and Functions
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Rank values in a range - Google Sheets Tutorial
From the course: Google Sheets: Advanced Formulas and Functions
Rank values in a range
- [Instructor] When you collect business data, you will often want to see where individual values rank within a larger data collection. In this movie I will show you how to calculate rank using a couple of different methods. This workbook contains a set of sales data. Those are in column A. And what I'd like to do is to find the rank of each individual item within that range using one or two methods. The first is Rank.AVG which will identify the rank and average values of tied ranks. And the second is to give equal numbered ranks to values that are the same. I'll show you what that means by working through this particular workbook. I'll start in cell B2. And type an equal sign. And the function I'll use is the column header Rank.AVG followed by a left parentheses. The value I want to compare to the entire range is in cell A2, another comma, and next I want identify the entire data range. So I'll select cells A2 through A12, but when I copy this range reference down, I don't want it to…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
(Locked)
Find the nth largest or smallest value1m 56s
-
(Locked)
Identify the smallest and largest values3m 49s
-
(Locked)
Rank values in a range4m 32s
-
Calculate distribution statistics3m 16s
-
(Locked)
Calculate values in the normal distribution8m 13s
-
(Locked)
Represent data using a mean of zero and standard deviation of one3m 26s
-
(Locked)
-
-
-
-
-