I have a list of words. I need to be able to add additional words to the
bottom of this list, and then to have the list automatically reordered in
alphabetical order in a separate column.

I cannot simply take the first letter and rank on it, for many of the words
have the same first letter, indeed some of the words have the same first five
letters, or possibly even more.

RANK clearly only works on numbers. Is there ANYTHING that works on words
in the same fashion? Or is there any combination of formula that will do it?

Cheers


Padster