Custom sort data based on list with more than 255 characters

[macquhele]

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

[aydeegee]

Hi macquhele

The way I would approach this is to create a table with all your characters and give them each a number. Using vlookup, bring these numbers across to a helper column and sort on that.

Hope this helps

Regards
Alastair