Download the featured file:
In this video I demonstrate how to rank values in Microsoft Excel.
This video will answer the following queries:
How to rank highest to lowest
How to rank lowest to highest
How to perform an average rank
How to rank without ties or duplicates
How to rank without skipping numbers
How to rank by group
How to rank by condition
How to create a RANK IF formula
Table of Contents:
00:00 - Introduction
00:18 - Rank scores using RANK.EQ
01:00 - Rank scores using RANK.AVG
01:42 - Rank giving smallest value a rank of 1
02:28 - Rank with no ties
04:35 - Rank by group - conditional ranking
------------------------
Источник: rutube.ru