RANK until next blank cell

[amonty78]

Simple question, but probably a complicated answer........I was wondering if there was any way to build a rank formula that will will rank starting at A1 for example, and then rank the values in column A until the next blank cell ?
The possible range wouldn't be any more than 30 cells down if that makes any difference.

[Special-K]

So you're ranking in multiple groups separated by a blank space,e.g.
This is without the rankings

Kevin  34
Mark 27
Paul 16

Michael 52
Annabel 48

Simon  13
Delia 5
Peter 27

Something like that ?

[Special-K]

With data starting on row 2 and names in column A and values to rank in column B

1. Create a Helper column in column C
in C2
=IF(A2="",C1+1,C1)
and copy down the column

2. in D2
=IF(A2="","",1+SUMPRODUCT((C$2:C$1000=C2)*(B$2:B$1000>B2)))

column D is your rank

[amonty78]

Yes, that works, thanks very much.