Sort dynamic list

[abdulhaque]

=OFFSET($D$2,0,0,COUNTA($D$2:$D$51)-COUNTIF(D2:D51,""),1 this is the formula that creates a dynamic list for a drop down using data from column D. Data in column D is not sorted in alphabetical order. Without having to sort the data in column D, can the list for the drop down using that formula be updated to also sort the data in the drop down?

 

[abdulhaque]

Re: Sort dymanic list

Got there in the end, thanks a lot