Sort List According to Order in Master List (formula)

[Filibuster]

I have an unsorted list that is a subset of a master list. Of the entries in the unsorted list, I'd like to sort the items according to the order in the master list. I would prefer to use formulas instead of macros (I know how to create a macro to accomplish this task). Thanks.

SortByMaster.xlsx

[Cutter]

In D6 this: =MATCH(B6,$A$6:$A$14,0)
In C6 this: =INDEX($A$6:$A$14,SMALL($D$6:$D$10,ROW(A1)))

copy both down

[haru]

Hi Filibuster,

I'm not sure if you can sort a list with just a formula, you would need to use the sort feature in Excel. I hope I'm wrong and a guru can help, it would be interesting to see.

EDIT - Nevermind, I stand corrected.

[Pete_UK]

Insert a new column C and put this formula in C6:

=MATCH(B6,A:A,0)

then copy down - it gives the row number where the item in column B exists in the master list in column A. Then put this formula in D6:

=INDEX(A:A,SMALL(C:C,ROWS(A$1:A1)))

and copy that down.

Hope this helps.

Pete

[Filibuster]

Thanks for the quick reply. Both solutions work great.

[Cutter]

You're welcome. Thanks for the 'star tap'.