Google Sheets

PERCENTRANK.EXC: Google Sheets Formulae Explained

How do you use PERCENTRANK.EXC in Google Sheets?

PERCENTRANK.EXC is a function in Google Sheets that calculates the percentage rank of a number in a list of numbers. The function takes two arguments: the number you want to calculate the percentage rank for and the list of numbers you want to calculate the percentage rank for. The function then calculates the percentage rank of the number you specified in the list of numbers.

What is the syntax of PERCENTRANK.EXC in Google Sheets?

The syntax of PERCENTRANK.EXC in Google Sheets is as follows:

=PERCENTRANK.EXC(number, array)

This function returns the percentage rank of a number in a given array. The number is compared to the values in the array, and the rank is determined based on the percentage of values that are less than or equal to the number.

What is an example of how to use PERCENTRANK.EXC in Google Sheets?

The PERCENTRANK.EXC function in Google Sheets can be used to calculate the percentage rank of a value in a list. The function takes two arguments: the value to be ranked and the list of values to be ranked. The function will return the percentage rank of the value in the list, where the value at the top of the list has a rank of 1 and the value at the bottom of the list has a rank of N, where N is the total number of values in the list.

When should you not use PERCENTRANK.EXC in Google Sheets?

There are a few occasions when you should not use the PERCENTRANK.EXC function in Google Sheets. One such time is when you are trying to find the rank of a number within a list of numbers, and that number is not included in the list. In this case, the PERCENTRANK.EXC function will return a #VALUE! error. Another time you should not use the function is when you are trying to find the rank of a number within a list of numbers, and that number is less than 0. In this case, the PERCENTRANK.EXC function will return a #N/A error.

What are some similar formulae to PERCENTRANK.EXC in Google Sheets?

There are a few similar formulae to PERCENTRANK.EXC in Google Sheets. PERCENTILE.EXC returns the percentile of a given value in a list, ranking values from smallest to largest. The QUARTILE.EXC function calculates the quartile of a given value in a list, ranking values from smallest to largest and dividing them into four equal parts. The MEDIAN.EXC function calculates the median of a given value in a list, ranking values from smallest to largest and selecting the middle value. Finally, the MODE.EXC function calculates the mode of a given value in a list, ranking values from smallest to largest and selecting the most common value.

Move beyond 

Google Sheets

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