From the course: Google Sheets: Advanced Formulas and Functions
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.