PERCENTRANK.EXC function: Description, Usage, Syntax, Examples and Explanation
What is PERCENTRANK.EXC function in Excel? PERCENTRANK.EXC function is one of Statistical functions in Microsoft Excel that returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set. Syntax of PERCENTRANK.EXC function PERCENTRANK.EXC(array,x,[significance]) The PERCENTRANK.EXC function syntax has the following arguments: Array: The array or range of data …