muppet77 said:whats the best way to get a value for a particular text cell , so that it ranks it in a list of cells, based on alphabetical order?
eg if i have cells a d c b, i want to get the correct ranks:
a 1
d 4
c 3
b 2
Derek said:Hi there
To add to Sitaram's excellent answer, you might like to ensure it reads the letters as capitals with this modification:
=CODE(UPPER(A1))-64
regards
Derek
Derek said:.PS If pushed I would probably try sorting the column alphabetically and then ranking it
muppet77 said:cheers chaps.
i should have actually said that the info was longer texts
apple
banana
orange
mango
cucumber
trying to avoid using the sort button if at all possible.
are we stumped????