Concatenate multiple cell values based on matching adjacent cells

Hi,

Trying to find the best way to concatenate varying amount of cells based on matching adjacent cell values.
Please see sample data and required output attached. The unique account numbers will already be on Sheet2, so only need the formula/function to populate the required output column.

Thanks!

Hi

Easiest way is with a User Defined Function.

Open a general module and enter the code

Please Login or Register  to view this content.

Then invoke (in your example file - update the ranges as required) as
=myfunc($A$4:$A$11,D4)

HTH

rylo

Hoping that this will help

It is automated to input on the column B

Thanks very much rylo and rcm!
Both methods worked perfectly.
Now it's time for me to study and undertand how they work :-)