Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts


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 with numeric values that defines…