emilyshaw93
New Member
- Joined
- Nov 11, 2015
- Messages
- 18
Hi all,
I have a list of data as follows:
<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
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 | John | JR, 4, 11, 26, 36, 85, 87, 96 | |
3 | Emily | 63, ES, 14, 1, 35 | Emily | ES, 1, 14, 35, 63 | |
4 | Kate | KM, 73, 25, 84, 13 | Kate | KM, 13, 25, 62, 73, 84, 94 | |
5 | John | 85, 96, 4 | |||
6 | Kate | 94, 62, 25, 13 |
<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