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
[TABLE="width: 500"]
<tbody>[TR]
[TD]ID
[/TD]
[TD]Name
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]John
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]John
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Max
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Haviar
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Jess
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Ron
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Ben
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]Marco
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]Marco
[/TD]
[/TR]
</tbody>[/TABLE]


Output Table[TABLE="class: outer_border, width: 100"]
<tbody>[TR]
[TD]ID
[/TD]
[TD]Formula
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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)