Hi!

Try this in column C:

=SUMPRODUCT(--($A$2:$A$34=A2),--(B2<$B$2:$B$34))+1

Biff

"SteveC" wrote in message
...
Column B contains numbers.

Column C should rank numbers in Column B, but only for sets of data
matched
by the Xs (X, XX, XXX, XXXX, etc.)

In other words, rank all figures in Column B for X, then rank all figures
in
Column B for XXm, etc...

Thanks for your help!

Column A Column B Column C
X 2
X
X
X
X
X
XX
XX
XX
XX
XXX
XXX
XXX
XXX
XXX
XXX
XXX
XXXX
XXXX
XXXX
XXXX
XXXXX
XXXXX
XXXXX
XXXXX
XXXXX
XXXXXX
XXXXXX
XXXXXX
XXXXXX
XXXXXX
XXXXXX
XXXXXXX