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
|