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 dont 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)


"Modeerf60" wrote:

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 dont 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

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

"Mike H" wrote:

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" wrote:

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 dont 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

To rank these in ascending order:

=SUMPRODUCT(--(A1A$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

--
Biff
Microsoft Excel MVP


"Modeerf60" wrote in message
...
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

"Mike H" wrote:

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" wrote:

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

Hello Mike,

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

Regards,
Bernd