Rank Data In Excel - RANK Function Complete Tutorial
This video describes covers the formula syntax and usage of the RANK function in Microsoft Excel.
When used the RANK function Returns a rank of a specific number from a list of numbers. Ranking a number means showing its size relative to other numbers in a data set.
====== PROFILE ======
https://hubpages.com/@joshuacrowder
===== CHAPTERS =====
00:00 Intro - Basics of Rank Function
00:14 What is the Rank Function
00:37 Function Syntax
01:06 Number Argument
01:26 Reference Argurment
02:06 Order Argument (optional)
03:38 Start Spreadsheet Example
04:21 Absolute Range Reference
05:10 Use Fill Handle
06:08 Color Scales Conditional Formatting
07:08 Highlight Less Than Conditional Formatting
07:55 Sort Rank column
09:01 Dynamic Rank Example
======== TAGS ========
#exceltutorial
#excelformula
#excel
#learnexcel
#exceltutorial
#microsoftexcel
#microsoftexceltutorial
#msexcel
#Spreadsheet
#excelfunctions
=== Recommendation ===
My MacBook Pro
https://www.amazon.com/dp/B0B8TGK8W6?tag=h...