RANK function in Excel and Rank by groups by Chris Menard

The Rank function in Excel returns the rank of a number in a list. You can rank in ascending or descending order. The RANK function has been replaced by the RANK.EQ function which came out with Excel 2010. With the RANK function, you do not have to sort.
This video came from Taylor who was sorting by revenue numbers descending and then manually ranking with 1, 2, 3, etc...
Countifs Function in Excel by Chris Menard
• COUNTIFS function in E...
The RANK.EQ function has three arguments. Two are required and one is optional.
RANK.EQ(number,ref,[order])
* Number is required. The number whose rank you want to find.
* Ref is required. An array of, or a reference to, a list of numbers. Non-numeric values in Ref are ignored.
* Order is optional. A number specifying how to rank number.
#msexcel #rankfunction #excel #countifs #functions
Chris Menard's Website:
chrismenardtra...
And make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera - amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod - amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera - amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording - Camtasia - chrismenardtra...
○ Screenshots - Snagit - chrismenardtra...
○ TH-cam keyword search - TubeBuddy - www.tubebuddy....
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!