How to concatenate values belonging to same text group?

**daksh1981** · 07-02-2010, 09:46 AM

Hi,
I am attaching a sample sheet with my query. In the attached sheet the result which has highlighted with color is the manual task, I want a macro to do this task automatically.
I am just concatenating the text of same group in column “E”.
Please let me know in case you need any further clarification on this.
Thanks for the help & support.

**Ron Coderre** · 07-02-2010, 10:05 AM

The kind of solution your requesting can quickly get out of hand when there are many tasks for the same project. I'd recommend using a Pivot Table to summarize the data. The results will be more organized and easier to read.

See the attached file for a peek at how it might work for you.

Is that something you can work with?

**daksh1981** · 07-02-2010, 10:23 AM

Thanks Ron for such a quick reply, but in my project I need a macro for doing this as I will print the output data in a shape after this concatenation.

**foxguy** · 07-03-2010, 08:14 PM

Hi daksh1981;
This will do all rows from 2 down in Column D, not just 2 to 10
It will look for matching values in Column A, even if they are not all together.
I put in a little extra formatting of Column E to make it easier to read.

Please Login or Register  to view this content.

**mikerickson** · 07-03-2010, 08:21 PM

You could use this UDF.
In E2, put

=ConcatIf(A:A, D2, B:B, ",")

and drag down.

Please Login or Register  to view this content.

**daksh1981** · 07-06-2010, 03:55 AM

Thanks foxguy and mikerickson, this is looking awesome...

Let me try this & I will revert with the status.

**snb** · 07-06-2010, 04:13 AM

After deleting the first empty row:

Please Login or Register  to view this content.

**daksh1981** · 07-06-2010, 08:39 AM

Thanks Ron,foxguy,mikerickson and snb this is really awesome I have got the solution. Thanks again for your great effort & support. God bless you all.

**foxguy** · 07-06-2010, 01:24 PM

You're welcome. I'm sure everyone involved would appreciate you rating their answers also.

**mrseanhogan** · 01-14-2014, 11:07 AM

Question on the below code. I want to match with wild characters. for instance i have an earlier Countif.....=COUNTIFS(A95:A100,LEFT(A95:A100,6)&"*") which returns 6
want to do the same here, but receiving blanks when applying the wild character "*" in this formula... =concatif(A95:A100,LEFT(A95:A100,6)&"*",E95:E100," "). Best I can figure is its looking for that left value plus a "*" at the end.

PS this is my first post so sorry if I did it wrong.

Originally Posted by mikerickson

You could use this UDF.
In E2, put

=ConcatIf(A:A, D2, B:B, ",")

and drag down.

Please Login or Register  to view this content.

How to concatenate values belonging to same text group?

LinkBack

Thread Tools

Rate This Thread

Display

How to concatenate values belonging to same text group?

Re: How to concatenate values belonging to same text group?

Re: How to concatenate values belonging to same text group?

Re: How to concatenate values belonging to same text group?

Re: How to concatenate values belonging to same text group?

Re: How to concatenate values belonging to same text group?

Re: How to concatenate values belonging to same text group?

Re: How to concatenate values belonging to same text group?

Re: How to concatenate values belonging to same text group?

Re: How to concatenate values belonging to same text group?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions