Rank lowest to highest using 2 columns

[audax48]

Hi, I need some help

I have 2 columns

A B
1 4.6
2 5.8
3 3.1
Blank
1 3.2
2 8.5
3 1.2
4 4.5
Blank
1 7.4
2 5.1

Need to Rank each group independently in column C, look at the Ex above the output in column c will be...

3
1
2
blank
3
1
4
2
blank
2
1

thank you very much

[biex]

Just made 3 rank table

on cell C2 =RANK(B2,$A$2:$B$4,0)

on cell C6 =RANK(B6,$A$6:$B$9,0)

on cell C11 =RANK(B11,$A$11:$B$13,1)

Drag it down to populate it with formula

Order of ranking
0 = Descending
1 = Ascending

[audax48]

Thank you biex, but I have several groups in the column, ex above was only a short example, can you help me if i have unlimited groups?

[harrisonland]

Assuming A1 has the value 1...

C1 is

Please Login or Register  to view this content.

C5 is

Please Login or Register  to view this content.

C10 is

Please Login or Register  to view this content.

If you were looking for a single formula to copy down, that'll take a bit of extra work.

Tim

[audax48]

Basically I need to rank only column b, ranking until find a blank cell, then rank again for the second group then 3rd group .....last group

[harrisonland]

See attached. Data starts in A2, so this goes into C2

Please Login or Register  to view this content.

Copy down, and voila!

Tim


EDIT: this will only work if there are fewer than 100 records bunched together. If there should be more edit the bits that say "OFFSET(A2,100,0)" and "OFFSET(B2,100,0)"