LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: mike.dasilva2@telus.com

Hi There,

Has anyone created code that mimics the function in excel for Percent Rank?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: timonk

Hello Mike,

I must admit I am not so throughouly versed in Excel, beyond the usual basics.

Could you perhaps post an example of what it is you want to do? Enough so I can be sure what I think you want, is what you actually are asking.

Thanks
Timon Koufopoulos,
MDA Support.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: mike.dasilva2@telus.com

Hey Timmon,

I'm trying to duplicate this

http://www.experts-exchange.com/Micr..._23773953.html

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: mmarinelli

I've attached a graph which implements Percent Rank per the scenario provided. I've never used this function in Excel myself, so I'm not sure if I've included all the proper functionality. For example, I'm not sure how the node should deal with duplicate values (see second static data input). Please give this example a try and report any limitations or issues you encounter.

EDIT: altered the graph to handle duplicates as identical rank by default
Attachments:
Percent Rank test.brg