Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Are PercentRank and Rankperc the same function?
Hello!
We are using the rankperc function of the analysis toolpak (Application.Run "ATPVBAEN.XLA!Rankperc"...). Just today I read that a lot of the ATP functions are now part of the regular worksheet functions in Excel 2007. I checked for the Rankperc but I could find the PercentRank function only. I'm not sure if this function does the same as the other function and I couldn't find any information about it on the web. Any help is appreciated. Rene |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Are PercentRank and Rankperc the same function?
Rene -
Worksheet functions that were part of the Analysis ToolPak add-in are native worksheet functions in Excel 2007 (not requiring that the Analysis ToolPak be installed). Also, if you want to use the Data Analysis wizards in Excel 2007, the Analysis ToolPak add-in must be installed. As far as I know, the PercentRank function has always been a standard worksheet function, not requiring the Analysis ToolPak add-in. As far as I know, the RankPerc function has always been an "Excel 4 macro programming language" function provided by the Analysis ToolPak. It can be used on an "MS Excel 4.0 Macro" sheet, or it can be called from VBA code using the syntax you show. You wrote that you "checked for the Rankperc." Since it's a function for macro sheets only, one place to check is the "MS Excel 4.0 Macro Function Help" file, available from the Microsoft web site. The RankPerc and PercentRank functions are not identical. According to documentation, RankPerc "returns a table that contains the ordinal and percent rank of each value in a data set, and " PercentRank "returns the percentage rank of a value in a data set." - Mike http://www.MikeMiddleton.com "renehug" wrote in message ... Hello! We are using the rankperc function of the analysis toolpak (Application.Run "ATPVBAEN.XLA!Rankperc"...). Just today I read that a lot of the ATP functions are now part of the regular worksheet functions in Excel 2007. I checked for the Rankperc but I could find the PercentRank function only. I'm not sure if this function does the same as the other function and I couldn't find any information about it on the web. Any help is appreciated. Rene |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel PERCENTRANK help | Excel Worksheet Functions | |||
Percentrank function display | Excel Worksheet Functions | |||
Percentrank Function Display | Excel Discussion (Misc queries) | |||
Percentrank Function | Excel Worksheet Functions | |||
what is the underlying formula for the percentrank function | Excel Worksheet Functions |