Make Data validation List Alphabetical??

S

Slumbering Gorilla

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

Slumbering Gorilla

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.
 
F

Frank Kabel

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" <[email protected]>
schrieb im Newsbeitrag
 
S

Slumbering Gorilla

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.
 
F

Frank Kabel

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" <[email protected]>
schrieb im Newsbeitrag
 
S

Slumbering Gorilla

Thanks Frank. made my life easier.

Frank Kabel said:
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" <[email protected]>
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.
Click to expand...
Click to expand...
 
Top