G
Gardien
If I have a spreadsheet with company names, is there a way to have them
alphabetize themselves?
alphabetize themselves?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
bigwheel
You could use the Sort facility. Check out "Sort a List" in the help file
D
Doug Kanter
Gardien said:If I have a spreadsheet with company names, is there a way to have them
alphabetize themselves?
How often does the list change and need to be sorted?
K
KB
Gardien said:If I have a spreadsheet with company names, is there a way to have them
alphabetize themselves?
J
James Silverton
Hello, KB!
You wrote on Sun, 15 Oct 2006 07:10:02 -0700:
K> "Gardien" wrote:
??>> If I have a spreadsheet with company names, is there a way
??>> to have them alphabetize themselves?
I suppose you could record a macro but sorting does not take
much time, especially if you have buttons for up and down
sorting.
James Silverton
Potomac, Maryland
E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not
You wrote on Sun, 15 Oct 2006 07:10:02 -0700:
K> "Gardien" wrote:
??>> If I have a spreadsheet with company names, is there a way
??>> to have them alphabetize themselves?
I suppose you could record a macro but sorting does not take
much time, especially if you have buttons for up and down
sorting.
James Silverton
Potomac, Maryland
E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not
B
Bill Ridgeway
Yes and no!
If you want to alphabetize on a "straight through" basis (regardless of
significant element) sort the company name field as is.
However, the significant part of a company name may be at the beginning or
part way through. Just consider the variation between Bill Ridgeway Co,
Ridgeway Co and Computer Solutions Co. You need to particularly clever when
it comes to some names though. Consider 'Clarke Brother & Sons'. If the
principals are 'Clarke' and 'Brother' the significant element is Clarke.
However, if the single principal is 'Clarke Brother' the significant element
is Brother. There are many variations on this theme.
If you have a helper column which contains the significant part of the name
(5 characters is usually all that is need) and sort on that you will have
control of how the data is sorted.
Regards.
Bill Ridgeway
Computer Solutions
If you want to alphabetize on a "straight through" basis (regardless of
significant element) sort the company name field as is.
However, the significant part of a company name may be at the beginning or
part way through. Just consider the variation between Bill Ridgeway Co,
Ridgeway Co and Computer Solutions Co. You need to particularly clever when
it comes to some names though. Consider 'Clarke Brother & Sons'. If the
principals are 'Clarke' and 'Brother' the significant element is Clarke.
However, if the single principal is 'Clarke Brother' the significant element
is Brother. There are many variations on this theme.
If you have a helper column which contains the significant part of the name
(5 characters is usually all that is need) and sort on that you will have
control of how the data is sorted.
Regards.
Bill Ridgeway
Computer Solutions