Make Data validation List Alphabetical??
 

how can i make my data validation list drop down, display my city names in
alphabetical order?

Hi
you need a sorted source list :-))

--
Regards
Frank Kabel
Frankfurt, Germany

"Slumbering Gorilla"
schrieb im Newsbeitrag
...
how can i make my data validation list drop down, display my city
names in
alphabetical order?

unfortunatly my sourcelist is part of a table. and reorginizing it will take
days. but if it comes down to it i will have to do that. but i just added a
data validation list, and not having it in alphabetical order makes it pretty
much useless due to the number of names in it. so i was trying to avoid
retypeing the table.

"Frank Kabel" wrote:

Hi
you need a sorted source list :-))

--
Regards
Frank Kabel
Frankfurt, Germany

"Slumbering Gorilla"
schrieb im Newsbeitrag
...
how can i make my data validation list drop down, display my city
names in
alphabetical order?

Hi
is this a long or short list. For the latter you could use a helper
column with formulas which sort your original data

--
Regards
Frank Kabel
Frankfurt, Germany

"Slumbering Gorilla"
schrieb im Newsbeitrag
...
unfortunatly my sourcelist is part of a table. and reorginizing it
will take
days. but if it comes down to it i will have to do that. but i just
added a
data validation list, and not having it in alphabetical order makes
it pretty
much useless due to the number of names in it. so i was trying to
avoid
retypeing the table.

"Frank Kabel" wrote:

Hi
you need a sorted source list :-))

--
Regards
Frank Kabel
Frankfurt, Germany

"Slumbering Gorilla"
schrieb im Newsbeitrag
...
how can i make my data validation list drop down, display my city
names in
alphabetical order?

so far the list is 90 and growing. 90x90 exactly.
Its a mileage table. with the headers being names of cities. and im useing
the headers for the list. so in one cell A3 i have the "from city" which are
the row headers, and in b3 "to city" which are the column headers.then in c3
it gives me the intersect (just to give you an idea what im useing it for).
the formula i have in it is
=evalcell(A3&" "&B3)
with a macro enabled

i was trying different thing to sort. but they kept conlflicting with the
above formula. just to let you know im pretty new at this.

but i was about to retype everything in from the handwritten originals. but
those arent in alphabetial order either. so its couple weeks of work since i
cant work on this exclusively.

but the main goal for this is to simplify and speed the city entries in A3
and B3. and typing it in is not too good since there are a lot of "_" and
misstypes are all too common around here.

"Frank Kabel" wrote:

Hi
is this a long or short list. For the latter you could use a helper
column with formulas which sort your original data

--
Regards
Frank Kabel
Frankfurt, Germany

"Slumbering Gorilla"
schrieb im Newsbeitrag
...
unfortunatly my sourcelist is part of a table. and reorginizing it
will take
days. but if it comes down to it i will have to do that. but i just
added a
data validation list, and not having it in alphabetical order makes
it pretty
much useless due to the number of names in it. so i was trying to
avoid
retypeing the table.

"Frank Kabel" wrote:

Hi
you need a sorted source list :-))

--
Regards
Frank Kabel
Frankfurt, Germany

"Slumbering Gorilla"
schrieb im Newsbeitrag
...
how can i make my data validation list drop down, display my city
names in
alphabetical order?

Hi
if you like send me an example sheet and I'll set something up for you
email: frank[dot]kabel[at]freenet[dot]de

--
Regards
Frank Kabel
Frankfurt, Germany

"Slumbering Gorilla"
schrieb im Newsbeitrag
...
so far the list is 90 and growing. 90x90 exactly.
Its a mileage table. with the headers being names of cities. and im
useing
the headers for the list. so in one cell A3 i have the "from city"
which are
the row headers, and in b3 "to city" which are the column
headers.then in c3
it gives me the intersect (just to give you an idea what im useing it
for).
the formula i have in it is
=evalcell(A3&" "&B3)
with a macro enabled

i was trying different thing to sort. but they kept conlflicting with
the
above formula. just to let you know im pretty new at this.

but i was about to retype everything in from the handwritten
originals. but
those arent in alphabetial order either. so its couple weeks of work
since i
cant work on this exclusively.

but the main goal for this is to simplify and speed the city entries
in A3
and B3. and typing it in is not too good since there are a lot of "_"
and
misstypes are all too common around here.

"Frank Kabel" wrote:

Hi
is this a long or short list. For the latter you could use a helper
column with formulas which sort your original data

--
Regards
Frank Kabel
Frankfurt, Germany

"Slumbering Gorilla"
schrieb im Newsbeitrag
...
unfortunatly my sourcelist is part of a table. and reorginizing
it
will take
days. but if it comes down to it i will have to do that. but i
just
added a
data validation list, and not having it in alphabetical order
makes
it pretty
much useless due to the number of names in it. so i was trying to
avoid
retypeing the table.

"Frank Kabel" wrote:

Hi
you need a sorted source list :-))

--
Regards
Frank Kabel
Frankfurt, Germany

"Slumbering Gorilla"

schrieb im Newsbeitrag
...
how can i make my data validation list drop down, display my
city
names in
alphabetical order?

Thanks Frank. made my life easier.

"Frank Kabel" wrote:

Hi
if you like send me an example sheet and I'll set something up for you
email: frank[dot]kabel[at]freenet[dot]de

--
Regards
Frank Kabel
Frankfurt, Germany

"Slumbering Gorilla"
schrieb im Newsbeitrag
...
so far the list is 90 and growing. 90x90 exactly.
Its a mileage table. with the headers being names of cities. and im
useing
the headers for the list. so in one cell A3 i have the "from city"
which are
the row headers, and in b3 "to city" which are the column
headers.then in c3
it gives me the intersect (just to give you an idea what im useing it
for).
the formula i have in it is
=evalcell(A3&" "&B3)
with a macro enabled

i was trying different thing to sort. but they kept conlflicting with
the
above formula. just to let you know im pretty new at this.

but i was about to retype everything in from the handwritten
originals. but
those arent in alphabetial order either. so its couple weeks of work
since i
cant work on this exclusively.

but the main goal for this is to simplify and speed the city entries
in A3
and B3. and typing it in is not too good since there are a lot of "_"
and
misstypes are all too common around here.

"Frank Kabel" wrote:

Hi
is this a long or short list. For the latter you could use a helper
column with formulas which sort your original data

--
Regards
Frank Kabel
Frankfurt, Germany

"Slumbering Gorilla"
schrieb im Newsbeitrag
...
unfortunatly my sourcelist is part of a table. and reorginizing
it
will take
days. but if it comes down to it i will have to do that. but i
just
added a
data validation list, and not having it in alphabetical order
makes
it pretty
much useless due to the number of names in it. so i was trying to
avoid
retypeing the table.

"Frank Kabel" wrote:

Hi
you need a sorted source list :-))

--
Regards
Frank Kabel
Frankfurt, Germany

"Slumbering Gorilla"

schrieb im Newsbeitrag
...
how can i make my data validation list drop down, display my
city
names in
alphabetical order?