MATLAB and Simulink resources for Arduino, LEGO, and Raspberry Pi
Learn moreOpportunities for recent engineering grads.
Apply TodayMATLAB Central > MATLAB Newsreader > replicating MS Excel percentrank formula 

Subject: replicating MS Excel percentrank formula From: Naresh Pai Date: 16 Sep, 2010 15:05:23 Message: 1 of 12 
I am trying to replicate MS Excel's percentrank function in Matlab. 
Subject: replicating MS Excel percentrank formula From: Ashish Uthama Date: 16 Sep, 2010 16:45:49 Message: 2 of 12 
Naresh, 
Subject: replicating MS Excel percentrank formula From: Naresh Pai Date: 16 Sep, 2010 19:04:08 Message: 3 of 12 
Ashish Uthama <first.last@mathworks.com> wrote in message <i6thju$ebg$1@fred.mathworks.com>... 
Subject: replicating MS Excel percentrank formula From: Roger Stafford Date: 16 Sep, 2010 19:32:21 Message: 4 of 12 
"Naresh Pai" <npai@uark.edu> wrote in message <i6tbnj$94h$1@fred.mathworks.com>... 
Subject: replicating MS Excel percentrank formula From: Ashish Uthama Date: 17 Sep, 2010 13:51:14 Message: 5 of 12 
Naresh, 
Subject: replicating MS Excel percentrank formula From: Victor Date: 21 Sep, 2010 13:20:05 Message: 6 of 12 
"Naresh Pai" <npai@uark.edu> wrote in message <i6tbnj$94h$1@fred.mathworks.com>... 
Subject: replicating MS Excel percentrank formula From: Skip Albertson Date: 13 Oct, 2010 18:11:04 Message: 7 of 12 
I had written a function to do this and offer it here. Depending on the data, you may need to sort it first and deal with replicates, otherwise this emulates the Excel PercentRank function fairly well: 
Subject: replicating MS Excel percentrank formula From: Michael Date: 15 Dec, 2010 20:56:05 Message: 8 of 12 
Hi, 
Subject: replicating MS Excel percentrank formula From: Michael Date: 15 Dec, 2010 22:42:05 Message: 9 of 12 
my bad ... 
Subject: replicating MS Excel percentrank formula From: David Date: 24 Oct, 2014 10:18:05 Message: 10 of 12 
Hi, I know this is an old thread but I cam up with this: 
Subject: replicating MS Excel percentrank formula From: David Date: 24 Oct, 2014 10:25:06 Message: 11 of 12 
"David" wrote in message <m2d90t$pfs$1@newscl01ah.mathworks.com>... 
Subject: replicating MS Excel percentrank formula From: David Date: 24 Oct, 2014 10:27:06 Message: 12 of 12 
"David" wrote in message <m2d90t$pfs$1@newscl01ah.mathworks.com>... 
A tag is like a keyword or category label associated with each thread. Tags make it easier for you to find threads of interest.
Anyone can tag a thread. Tags are public and visible to everyone.