MATLAB: Assign Ranking in Matlab

cellsrankingrowssort

I have several cell-type variables A{Y,1}(Z x 13 cells) all sorted by column C. I need to assign a ranking (add column R) for the corresponding sorting order.
Example for a B {Y,1} (8 x 3 cells). My original cell is:
A   B      C        
MJ 65   0           
MJ 321  0,0125      
MJ 2    0,0125      
MJ 1987 0,0125    
MJ 87   0,02        
MJ 5    0,0375      
MJ 743  0,0375      
MJ 124  0,05
I would like to rank (column R) each A{Y,1} cell-type, considering that in case of tie, the mean value should be assigned.
A   B      C        R
MJ 65   0           1
MJ 321  0,0125      3   %Assign mean value

MJ 2    0,0125      3
MJ 1987 0,0125  >>  3
MJ 87   0,02        5
MJ 5    0,0375      6,5 %Assign mean value
MJ 743  0,0375      6,5
MJ 124  0,05        8
Thanks for your help.

Best Answer

   v={'MJ' 65   0           
'MJ' 321  0.0125      
'MJ' 2    0.0125      
'MJ' 1987 0.0125    
'MJ' 87   0.02        
'MJ' 5    0.0375      
'MJ' 743  0.0375      
'MJ' 124  0.05}
[a,b,c]=unique([v{:,3}])
d=accumarray(c,(1:numel(c))',[],@mean)
v(:,4)=num2cell(d(c))
Related Question