5 Reasons to use COUNTIF - #2 Unique Ranking of Values

Create a unique ranking of values using the COUNTIF function. When ranking values in Excel using the RANK function, if two values are equal then a ranking is skipped. Without a unique ranking you cannot create a league table. This video tutorial shows how you can create a unique ranking using the COUNTIF function. This video is the second in the '5 Alternative Reasons to use COUNTIF' series. The COUNTIF function is used to count records that meet specific criteria. It is one of the most useful functions in Excel, especially for analysing data and reporting. This video series looks at 5 alternative reasons to use the COUNTIF function. The other videos in the series can be found using the links below. #1 – Prevent Duplicate Entries in a Range - https://youtu.be/N2WV_rO_y2s #3 - Compare Two Lists using COUNTIF - https://youtu.be/HUWrnLOOGsQ #4 - Create a Distinct Count Formula - https://youtu.be/sRUSLs6YaK0 #5 - Identify Names that Occur 3 or More Times - https://youtu.be/1CSpFBZk0X8