ExcelBanter - Need sorted validation list

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Need sorted validation list (https://www.excelbanter.com/excel-worksheet-functions/46953-need-sorted-validation-list.html)

[email protected]

Need sorted validation list

Hi. I have a range of cells that are NOT sorted and should not be
sorted on the worksheet. I want to use that range as a Data Validation
List, but I want the values to be sorted on the validation list.

Any suggestions?

Thanks!

Ken

All times are GMT +1. The time now is 09:49 PM.