Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what is the underlying formula for the percentrank function
what is the underlying formula for the percentrank function
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what is the underlying formula for the percentrank function
Hi Geff.
The PercentRank formula of... PERCENTRANK(array,x,significance) where... array is the array or range of data with numeric values that defines relative standing. x is the value for which you want to know the rank. comes from... =(MATCH(x,array)-1)/(COUNTA(array)-1) HTH, -- Gary Brown If this post was helpful, please click the ''Yes'' button next to ''Was this Post Helpfull to you?''. "geff" wrote: what is the underlying formula for the percentrank function |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
create pivot table formula without the GETPIVOTDATA function | Excel Discussion (Misc queries) | |||
function CELL() to return the formula in the referenced cell | Excel Worksheet Functions | |||
Add to my Function / formula | Excel Worksheet Functions | |||
how to enter a formula using column() function for a range | Excel Worksheet Functions |