rank text

[Duane]

I'd like to mimic the RANK function with an array of text values.

Can I get a numerical value from each of a list of names?

For example:

A1 = George Bush
A2 = Barack Obama
A3 = Abraham Lincoln
A4 = James K. Polk

TEXTRANK(A1)=3
TEXTRANK(A2)=2
TEXTRANK(A3)=1
TEXTRANK(A4)=4

 

[Gary''s Student]

in B1:

=COUNTIF($A$1:$A$26,"<"&A1)+1 and copy down to display:

George Bush 3
Barack Obama 2
Abraham Lincoln 1
James K. Polk 4

 

[Duane]

Hm. Well, that certainly was simple! Thanks a ton for replying. I guess I
didn't realize that a text string could be < or > than another. I'll
remember that.
By the way, your answer just helped finish a cub scout pinewood derby
utility. Many thanks.

 

[Gary''s Student]

Thank you for the feedback.