Are PercentRank and Rankperc the same function?

[renehug]

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

 

[Mike Middleton]

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


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