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