Tricky sorting problem

[Tipsey]

I have a list of ID numbers in a table in a random order that I want sorted in ascending order. I also have a column in the table which has flagged certain people as working together and I would like the final sorted list to include the people working together directly following the person with the lowest I'd number from that group.

Ie.

2 a x
1 b
3 c 1
4 d
6 e x
5 f 1

Should sort to:

1 b
2 a x
6 e x
3 c 1
5 f 1
4 d

There is no way of knowing how many id's there will be or what the identifier used to group the different people will be.

VBA is not supported either.

Thanks for any you can provide.

 

[Legacy 143009]

In your example, who are working together with whom?

 

[Kerryx]

I was thinking this but x's and 1,s make it ricky all right

Book1
	A	B	C
1	ID	Name	Group
2	1	b
3	2	a	x
4	3	c	1
5	4	d
6	5	f	1
7	6	e	x
Sheet1

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F	G
1	Id	Name	Group		Id	Name	Group
2	2	a	x		1	b
3	1	b			2	a	x
4	3	c	1		6	e	x
5	4	d			3	c	1
6	6	e	x		5	f	1
7	5	f	1		4	d
Active

Cell Formulas
Range	Formula
E2:G7	E2	=LET(a,SORT(A2:C7,1),s,IF(a="","",a),SORTBY(s,IF(INDEX(s,,3)="",INDEX(s,,1),INDEX(s,MATCH(INDEX(s,,3),INDEX(s,,3),0)))))
Dynamic array formulas.

 

[Tipsey]

Thank you for the quick reply, it is good to know my brain was heading in the right direction thinking let and match, but I appreciate the help figuring this one out.

 

[Fluff]

Glad we could help & thanks for the feedback.