Excel

PERCENTRANK: Excel Formulae Explained

How do you use PERCENTRANK in Excel?

The PERCENTRANK function in Excel calculates the percentage rank of a value in a list of values. The function takes two arguments: the value to calculate the rank for, and the list of values to compare the value to. The function returns the rank of the value as a percentage, where the rank of the first value is 1, the rank of the second value is 2, and so on. The function can be used to compare values in a list to see which value is the highest or lowest, or to find the rank of a value in a list.

What is the syntax of PERCENTRANK in Excel?

The syntax of PERCENTRANK in Excel is as follows:

=PERCENTRANK(range, criteria)

Where:

range is the range of cells you want to calculate the percent rank of

criteria is the criteria you want to use to rank the cells

What is an example of how to use PERCENTRANK in Excel?

The PERCENTRANK function in Excel calculates the rank of a given value within a set of values, and returns that rank as a percentage. For example, if you have a list of numbers and you want to find out which number is the third largest, you can use the PERCENTRANK function to help you do so. In the example below, the value in cell C3 is the third largest number in the list.

When should you not use PERCENTRANK in Excel?

There are many occasions when you should not use percent rank in Excel. One instance is when you have a column of numbers that are not ranked in any order. In this case, percent rank will not return any meaningful results. Another time you should not use percent rank is when you have a column of text values. Excel will not be able to calculate percent rank for text values and will return the #VALUE! error. Additionally, percent rank should not be used with data that has been sorted in reverse order, as it will not return accurate results.

What are some similar formulae to PERCENTRANK in Excel?

The PERCENTRANK function in Excel is used to calculate the percentage rank of a value in a list of values. The function takes two arguments: the value to calculate the rank for and the list of values to compare it to. The function will return the percentage rank of the value in the list of values. The function can be used to calculate the percentage rank of a value in a list of numbers, a list of text values, or a list of dates.

Some similar formulae to PERCENTRANK in Excel include:

=AVERAGE(B3:B9) =MEDIAN(B3:B9) =MODE(B3:B9)

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.