Help merging, filtering and sorting complex data

[emilyshaw93]

Hi all,

I have a list of data as follows:

	A	B	C	D	E
1	NAME	REFERENCES		NAME (Sorted)	REFERENCES (Sorted)
2	John	36, 87, JR, 11, 26 <tbody> </tbody>		John	JR, 4, 11, 26, 36, 85, 87, 96
3	Emily	63, ES, 14, 1, 35 <tbody> </tbody>		Emily	ES, 1, 14, 35, 63
4	Kate	KM, 73, 25, 84, 13 <tbody> </tbody>		Kate	KM, 13, 25, 62, 73, 84, 94
5	John	85, 96, 4 <tbody> </tbody>
6	Kate	94, 62, 25, 13 <tbody> </tbody>

<tbody>
</tbody>

What I want to do is get the data in column B to sort into column E automatically. I want multiple data sets for John, for example, to combine, sort in ascending order, and remove duplicates (as shown in E above), automatically.

I have set up column d to sort names and remove duplicates within the list in column A already - I need a formula to do a similar thing for putting the data in column B into column E.

Any help much appreciated!

Emily

 

[Macropod]

Duplicate of http://www.mrexcel.com/forum/excel-questions/905151-sorting-complex-data-excel-help.html
Please read our policy on Cross-Posting in rule #12: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html

Thread closed.