Ranking Strings

[Amateurhr]

There's a vba function called Application.Rank which can tell me the rank of a number amongst a range of other numbers.

Is there a corresponding function that can do this with alpha strings?

I want to rank something like this:

{ Ralph, Amanda, Chester }

and have that give me the following rank:

{ 3, 1, 2 }

[jproffer]

Assuming you mean Ranking alphebetically, and if you can live with a helper column (which could be hidden, naturally), you could do something like this:

Excel 2007

	A	B	C	D
1	Ralph	82	3
2	Amanda	65	1
3	Chester	67	2
4	………………	………………	………………	………………

Sheet1

Worksheet Formulas Cell Formula B1 =CODE(LEFT(A1,1)) C1 =RANK(B1,$B$1:$B$3,1) B2 =CODE(LEFT(A2,1)) C2 =RANK(B2,$B$1:$B$3,1) B3 =CODE(LEFT(A3,1)) C3 =RANK(B3,$B$1:$B$3,1)

[T. Valko]

There's a vba function called Application.Rank which can tell me the rank of a number amongst a range of other numbers.

Is there a corresponding function that can do this with alpha strings?

I want to rank something like this:

{ Ralph, Amanda, Chester }

and have that give me the following rank:

{ 3, 1, 2 }

Like this...

Sheet1

	A	B
2	Ralph	3
3	Amanda	1
4	Chester	2

This formula entered in B2 and copied down:

=COUNTIF(A$2:A$4,"<"&A2)+1

[Amateurhr]

Thank you, I used Application.Countif and everything works great

[T. Valko]

Thank you, I used Application.Countif and everything works great

You're welcome. Thanks for the feedback!