Making a list of unique ID's

[nbendotron]

Hi,

I am trying to create a formula that will identify unique ID's and pull them into a list in one cell that shows each unique ID separated by semi colons.

Data Table

ID	Name
1	John
1	John
1	Max
2	Haviar
3	Jess
3	Ron
3	Ben
4	Marco
4	Marco

<tbody>
</tbody>

Output Table

ID	Formula
1	???
2
3
4

<tbody>
</tbody>

The formula would return "John; Max" in B2, "Haviar" in B3, "Jess; Ron; Ben" in B4, and "Marco" in B5. I know this is difficult, but I appreciate anyone that tries, thanks

 

[jeffreybrown]

Here's a start, but if you remove duplicates first then this would make matters better.

Post #7

=foo($A$2:$A$10,E1)