Forum Discussion
jonahw218
Feb 29, 2020Copper Contributor
Custom Sort Alphabet Alphabetizing
So I want to alphabetize a list with a custom list of symbols. I've tried the custom list function but this only sorts cells if the exact word/symbols are in that custom list. For example, if I h...
Riny_van_Eekelen
Feb 29, 2020Platinum Contributor
jonahw218 Inspired by the work of Ghazanfar Abidi, and just for the fun of it I amended my original file and made it "fully dynamic". Make sure that the order of the "key" to your alphabet is in accordance with the sorting order that Excel is using (i.e. numbers first, then symbols, then letters).