Need RANK Function for Text

  • Thread starter Thread starter Modeerf60
  • Start date Start date
M

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
 
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)
 
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
 
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
 
Back
Top