Excel: sort an array by an ordered list, without custom list
I have a table of post codes, with the amount of shipments being sent to each postcode.
I want to sort this array by post code in a specific order, which I have in a second list.
I do not wish to sort by number of customers, or by numerical order of post codes, but by this specifically ranked list.
I cannot use the custom sort feature, as my list is too long for this feature.
Why does a `UNIQUE(TEXTSPLIT(TEXTJOIN(…)))` not yield a list of unique values?
I was trying to help solving this question.