Custom sorting: larger master list sorted first by the smaller unique items list selected that day

[ok_lets]

I may have already answered my own question but I have just discovered xl2bb so I will post anyway: when I say answered this only means that I won't (please correct me here) be able to achieve what I want by sorting alone so will need to think on or look for guidance/answers here.

(Not sure this first time if xl2bb picks up comments so my question follows - the comments if picked up may help make it clearer)

I have a master list of items col A.
Each day items are picked from that list col B.
col C is unique items for that day and col D is sorted col C.
In this example I want in col E - the master list - sorted by the "sorted unique for the day" in col D:
the sort order should be master list sorted in a 2 part fashion of: -
- top most portion of list should equal the "daily unique" in col D
- the rest of master list after that - but equalling exactly the master list items but sorted as above.

Thanks in advance

test.xlsm
	F
7
Sheet24

 

[ok_lets]

Hmmm...could someone tell me have I used xl2bb correctly - thought I had - but how is it viewed?

 

[ok_lets]

Ha, ha, ha,....! Please excuse my earlier incompetence below is the mini sheet:

test.xlsm
	A	B	C	D	E
1	1	1	1	1	#VALUE!
2	1x	1x	1x	2
3	2x	1x	2x	4
4	2	2x	2	5
5	30	2	32	12
6	3	2	99	31
7	32	32	432	32
8	321	99	5st	33
9	231	1x	4ew	99
10	432	432	31th	121
11	99	5st	4	432
12	4w	5st	5	1x
13	4ew	4ew	31	2x
14	4rd	31th	33	31th
15	4	4	12	4ew
16	5	5	121	4rd
17	5st	4	4rd	5st
18	11	5
19	12	31
20	31th	33
21	31tth	31th
22	31tthh	5st
23	31	432
24	33	12
25	121th	121
26	121	432
27	131	12
28	1313	121
29	2121212	4rd
30
31
32
33
34
35
36
37
38
39
40
Sheet24

Cell Formulas
Range	Formula
C1:C17	C1	=UNIQUE(B1:B29,,FALSE)
D1:D17	D1	=SORT(C1#,1,1)
E1	E1	=SORTBY(A1:A29, D1#, 1)
Dynamic array formulas.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=SORTBY(A1:A29,XMATCH(A1:A29, D1#), 1)

 

[ok_lets]

Hi & welcome to MrExcel.
How about

=SORTBY(A1:A29,XMATCH(A1:A29, D1#), 1)

Spot on Fluff!
You know I looked at and then immediately looked away from a match solution - he, he, he! (doh!)
And thank you Fluff for the welcome

 

[Fluff]

You're welcome & thanks for the feedback.