View Single Post
  #3   Report Post  
Bernd Plumhoff
 
Posts: n/a
Default

If your values are in A1:A14, then enter in cell B1:

=SUM(ROW(INDIRECT(RANK($A1,$A$1:$A$14,TRUE)&":"&RA NK
($A1,$A$1:$A$14,TRUE)+COUNTIF($A$1:$A$14,$A1)-1))/COUNTIF
($A$1:$A$14,$A1))

Enter this formula with CTRL+SHIFT+ENTER (as array
formula). Finally copy it down to B14.

HTH,
Bernd