Vlookup & return all unique values to a single cell

Hey all, I have been googling till i cant google no more. I am trying to do what a guy in the thread below is asking but i do not see it really answered.

Original Thread: http://www.ozgrid.com/forum/showthread.php?t=25239

Here is his sample:
ColumnA-----------ColumnB
ABC----------------123
ABC----------------456
ABC----------------678
XYZ----------------444
XYZ----------------555

What is not answered is his second part: "But I am really and idiot with VBA. What happens if I only want to return a single instance of duplicated data?" How do can i get the data to show up like this:

Cell C1 -> 123, 456, 678
Cell C2 -> 444, 555

My data does NOT always have 3 digits nor does it just have numbers. I have to do this on 16K+ lines in 3 different categories and having a very hard time figuring out how to do this.

This may not be the exact answer, but how about...

PY_,

Attached is an example file based on the criteria you described.
Row 1 is a header row so actual data starts in row2
Column A contains the ABC/XYZ stuff
Column B contains the numbers
Column D is a unique list from columns A (I used the Advanced Filter)
Column E is the list of unique items from column B, and is obtained by using this array formula in cell E2 and copied down. Note that array formulas must be entered with Ctrl+Shift+Enter and not just Enter. That's how the formula gets surrounded by the curly brackets {}, do not try to add those manually.

Please Login or Register  to view this content.

The ConcatAll function is a UDF I created (original thread here: http://www.excelforum.com/tips-and-t...geravatar.html). The code being used is from post #8 in that thread:

Please Login or Register  to view this content.

As you can see it only returns the unique values and does not repeat them. If you need a pure VBA solution and not a UDF, let me know and I can provide that.

could make use of a pivot table to summarize you data and then build the output combinations from that?

How unique are your 75k rows?

I think you may want to look at Andy's idea again, although your current needs are met, Pivot Tables (properly defined) can be a great resource...at least give it a shot