Return corresponding matches without duplicates and comma seperated

[pakian]

guys, please what the function or formula should i put on. see my file

[xladept]

Here's a function:

Paste this code into a standard module

Please Login or Register  to view this content.

Then enter this in N4 and drag down

Please Login or Register  to view this content.

[pakian]

Is there any function without using vba ?

[xladept]

The function I gave you is very versatile - it can be used with VBA code or as an UDF in the worksheet as I demonstrated - You could even turn it into an add-in if you don't want a module in your project. But to construct a formula for this task is not in my area of expertise yet - Good Luck!

[pakian]

ok thx ,xladept that's so helpful, you are so excellence, where can i read the articles about excel-vba, because i really want to learn it

[xladept]

You're welcome!

I have a copy of "Excel 2003 Power Programming" by John Walkenbach which I procured from Amazon for only $20 - I bought that recently. Before that I used "Writing Excel Macros" by Steven Roman and that's the book I used for over a decade.

[pakian]

i see, can u give me the code for my recent thread

http://www.excelforum.com/excel-prog...-with-vba.html

thank alot for sharing