How to Rank Duplicate Values in Excel
Vložit
- čas přidán 2. 08. 2024
- Let's look at how to rank duplicate values in Excel, add a rank for values in a list or range but also check and order duplicate values properly. We look at how to create a dynamic chart from a list of values, ordered by rank. The rank is determined using the RANK function, but we make sure that we rank them in order, even if there are duplicate values or some of them have a tie.
I also show you how to enable Workbook Stats, so that you can inspect all the objects and other things you have in your entire workbook. We also look at how to hide or show a chart in Excel, by using the selection pane. This is an Excel Advanced tutorial and I show several tips about RANK, COUNTIF, stats, charts and I will be developing some of these topics in future videos quite soon.
Chapters:
00:00 Introduction
01:16 Hide or show a chart in Excel
01:59 Excel Workbook stats
02:49 RANK values
03:58 RANK duplicate values
05:27 Evaluate formula
06:33 Closing remarks
Check out more Excel Tutorials here:
• Microsoft Excel Videos
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 - chrismenardtraining.com/camtasia
○ Screenshots - Snagit - chrismenardtraining.com/snagit
○ CZcams keyword search - TubeBuddy - www.tubebuddy.com/chrismenard
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!
#excel #rankvalues #countif
the ranking without showing the duplicate result rank is another level... thank you for this
God Bless You, your simple trick solved a problem i had been struggling to deal with for years
Thank you
Nice solution for tied rank. I'm definitely going to use that one!
Thanks, Robert. I had to use it to make a chart work.
Big help .boss😊
Glad to help.
Dude it's totally wrong formula. 1200 is both are in rank first then how can u calculate the the one 1200 is 1st dhe other is 1200 is 2nd. Correct this 3rd rank into 2nd then I'll subscribe your channel.