Hi there

Does anyone know how to sort a column of data based on a custom list with more than 255 characters.

I have created a named range with 40 entries and then added data validation in the cells of column D using the above named range. However, I want to be able to sort column D in the same order as the named range but the custom data sort lists are restricted to 255 characters.

Any help would be greatly appreciated.

Regards