Need RANK Function for Text

[Modeerf60]

I need a function like RANK (which is for numbers), but only for text. The
sort feature is not a function I can use in a formula. Rank permits me sort
numerically but I want to sort alphabetically.

I don’t see a function that does this and have tried a few options to do
this with things like CODE but have been unsuccessful.

Can you help, please.

M

 

[Mike H]

Perhaps you need to post some ranked/unranked text and explain the logic for
the rank
--
Mike

When competing hypotheses are equal, adopt the hypothesis that introduces
the fewest assumptions while still sufficiently answering the question.
Occam''''s razor (Abbrev)

 

[Modeerf60]

The logic is simply to perform alpha sort via funtion. I really need exact
the same result as RANK except for text. The ranking would be according to
the alphabetical order.
M

 

[T. Valko]

To rank these in ascending order:

=SUMPRODUCT(--(A1>A$1:A$15))+1

astronomer = 1
avon = 2
camel = 3
cornhusks = 4
cover = 5
earthday = 6
feedback = 7
galvani = 8
hospitals = 9
lights = 10
metronome = 11
pawl = 12
roseanne = 13
snacks = 14
splint = 15

To rank these in descending order:

=SUMPRODUCT(--(A1<A$1:A$15))+1

splint = 1
snacks = 2
roseanne = 3
pawl = 4
metronome = 5
lights = 6
hospitals = 7
galvani = 8
feedback = 9
earthday = 10
cover = 11
cornhusks = 12
camel = 13
avon = 14
astronomer = 15

 

[Bernd P]

Hello Mike,

Have a look here:
http://sulprobil.com/html/sorting.html

Regards,
Bernd