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.
I would like the outcome to look something like the following:
I have office 2016 however for this task I have been trying web based office 365 for use of the sort functions
I have tried the use of SORT and SORTBY but however I format them, I am given the #VALUE! error.
I tried the following formula, but it threw #VALUE!
=SORTBY(A2:B944, D2:E2639)
2
You could also utilize an index match function (formulas are assuming you are utilizing tables and not the cell ranges):
=index(Table1[Customer Postcode], match(Table2[RANKINGS], Table1[RANKINGS], 0))
Make your 2nd table in the A column hold static numbers you want to look up, then fill B Column with your Customer Postcode. Then you can make your C Column index match your B column back to table 1.
=index(Table1[Customers], match(Table2[Customer Postcode], Table1[Customer Postcode], 0))