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

Why not add you words to the bottom of the column and with the selected cell
in that column click

Data|sort and off you go.

Mike

"Padster" wrote:

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

Sorry, I need to explain more fully what I am trying to do.

I have an excel spreadsheet that I have built with a view to aiding in the
creation of characters for a role-playing game called Chivalry & Sorcery.
The spreadsheet has two sheets, amongst others, called €œVocation€� and €œCW
Cust€� (standing for €œCampaign World Customisation€�).

€œVocation€� details all the available vocations a character can follow. This
list is a fixed list of over 50 different vocations.

The €œCW Cust€� sheet allows the user to ADD more vocations to this list, at
the bottom of the list.

Once the user has customised the vocations for his world, he would then
start to create characters for his world, and should be able to select the
custom vocations he created in the €œCW Cust€� sheet, if he wishes to.

I want the list that appears to the user when creating the character to
always appear in alphabetical order. No matter what additional vocations he
may have added, and this needs to happen automatically. I do not want the
user to have to intervene and have to sort the list before it is usable in
alphabetical order drop down box that it currently appears in.

I understand that in VBA one can create an EVENT that could drive a
resorting of my list of vocations on the €œVocation€� tab, if the cell on the
€œCW Cust€� tab into which the user must enter the new vocation for their world
is altered in any way. But my VBA skills are non-existant and the only
reason I know this is I was told. I want to avoid VBA if possible and keep
things to formulas.

Cheers


Padster



"Mike H" wrote:

Why not add you words to the bottom of the column and with the selected cell
in that column click

Data|sort and off you go.

Mike

"Padster" wrote:

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

Could you not create a Pivot Table with its limits set to a row number below
your data or all 65000+ rows? In the Pivot Table set the field to sort
ascending by right clicking on the field to sort and then Field Settings,
Advanced and Ascending

"Padster" wrote:

Sorry, I need to explain more fully what I am trying to do.

I have an excel spreadsheet that I have built with a view to aiding in the
creation of characters for a role-playing game called Chivalry & Sorcery.
The spreadsheet has two sheets, amongst others, called €œVocation€� and €œCW
Cust€� (standing for €œCampaign World Customisation€�).

€œVocation€� details all the available vocations a character can follow. This
list is a fixed list of over 50 different vocations.

The €œCW Cust€� sheet allows the user to ADD more vocations to this list, at
the bottom of the list.

Once the user has customised the vocations for his world, he would then
start to create characters for his world, and should be able to select the
custom vocations he created in the €œCW Cust€� sheet, if he wishes to.

I want the list that appears to the user when creating the character to
always appear in alphabetical order. No matter what additional vocations he
may have added, and this needs to happen automatically. I do not want the
user to have to intervene and have to sort the list before it is usable in
alphabetical order drop down box that it currently appears in.

I understand that in VBA one can create an EVENT that could drive a
resorting of my list of vocations on the €œVocation€� tab, if the cell on the
€œCW Cust€� tab into which the user must enter the new vocation for their world
is altered in any way. But my VBA skills are non-existant and the only
reason I know this is I was told. I want to avoid VBA if possible and keep
things to formulas.

Cheers


Padster



"Mike H" wrote:

Why not add you words to the bottom of the column and with the selected cell
in that column click

Data|sort and off you go.

Mike

"Padster" wrote:

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