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 |
<tbody> </tbody> | John | JR, 4, 11, 26, 36, 85, 87, 96 | ||
3 | Emily |
<tbody> </tbody> | Emily | ES, 1, 14, 35, 63 | ||
4 | Kate |
<tbody> </tbody> | Kate | KM, 13, 25, 62, 73, 84, 94 | ||
5 | John |
<tbody> </tbody> | ||||
6 | Kate |
<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