1
0
Is there any way to sort a list into tuples as defined by a priority list in Excel?
For example I would do a draw to get priorities:
Banana -> 1
Apple -> 2
Tomato -> 3
And I have sheet of randomly ordered data:
Tomato
Banana
Banana
Tomato
Apple
Tomato
Banana
Apple
Banana
Banana
Now I want to sort into tuples by the priority list to get this result:
Banana
Apple
Tomato
Banana
Apple
Tomato
Banana
Tomato
Banana
Banana
The tuples are complete to the extent values exist in the data list.
Welcome to Super User! It's not clear to me how these priorities are being applied. Can you explain how the priorities lead to that output? – Excellll – 2015-11-01T01:59:04.987
With or without VBA? – Raystafarian – 2015-11-02T16:02:21.840