Hi all ,
I'm a newbie at Excel.
I wonder if there is a way to sort the dropdown list created though data validation tool.
The data in the dropdown list is from the data in another column.
The data in that column is not sorted and shouldn not be sorted.
But I need the data in the dropdown alphabetically sorted.
Is it doable without creating another new sorted column?
The way I created the dropdown is as normal, creating a name asscoiating with the range
of the source data column and use data validation tool to create a list associating with this defined name.
Any suggestions or comments are welcome.
Thanks in advance.
-Tian
Bookmarks