I have large data running into many rows and new data is added regulary. As it is updated regulary, it is not possible to sort it every time.
I am using a normal LIST validation for getting drop down list. The data shown in the drop down menu is not sorted out.
I want that the data should be shown in a sorted manner in the drop down menu (irrespective of the type of data at the source).
I am attaching a sample file. Please suggest.
Thanks