Ranking within subgroups

[Guest]

I defined dynamic nameranges (OFFSET function), and would like to refer to
these ranges. A formula in a row should refer to a namerange depenent on a
textvalue in the prev. row.

Example :
A: B: C:
vessel1 =RANK(C1 ; [vessel1] ; 1) 8
vessel1 .... 15
..... .... 20
vessel2 =RANK(C1 ; [vessel2] ; 1) 3
vessel2 .... 7
..... .... 10
value in cells and nameranges are named identically,
table is in sorted order, OFFSET function , eg [vessel1] refers to C1:C3
does someone know how to get it worked or maybe an alternative solution ?

 

[Guest]

Stefan

Try this: =RANK($B$2:$B$7,B2)-COUNTIF($A$2:A2,A2)+COUNTIF($A$2:$A$7,A2)

Peter

 

[Guest]

Hi
I forgot to say enter on top row and copy down.

Peter

 

[Guest]

Ugh
It only works if the data is sorted by Type then Score, or (score within Type)

Peter

Hi
I forgot to say enter on top row and copy down.

Peter

I defined dynamic nameranges (OFFSET function), and would like to refer to
these ranges. A formula in a row should refer to a namerange depenent on a
textvalue in the prev. row.

Example :
A: B: C:
vessel1 =RANK(C1 ; [vessel1] ; 1) 8
vessel1 .... 15
.... .... 20
vessel2 =RANK(C1 ; [vessel2] ; 1) 3
vessel2 .... 7
.... .... 10
value in cells and nameranges are named identically,
table is in sorted order, OFFSET function , eg [vessel1] refers to C1:C3
does someone know how to get it worked or maybe an alternative solution ?

 

[T. Valko]

Try this formula entered in B1 then copied down:

=SUMPRODUCT(--(A$1:A$10=A1),--(C1>C$1:C$10))+1

Biff