Using Rank with If
Assuming that A2:B10 contains the data, to rank Column B from highest to
lowest, try...
C2, copied down:
=SUMPRODUCT(--(A$2:A$10=A2),--(B2<B$2:B$10))+1
Hope this helps!
In article ,
SteveC wrote:
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
|