# Concatenate by criteria

#### imported_unknown

##### Active Member
2002_09_30 - Simon.xls
ABCD
1ProjectsNotesSummaryReport
2Project1BuiltairplaneProject1Builtairplance;Buildboat
3Project2DrankbeerProject2Drankbeer;Wentbowling
4Project1Buildboat
5Project2Wentbowling
Sheet1

Hi All,

I'd like to know how to concatenate cells that meet a specific criteria. In the example above, I want to create report that shows the notes for each project.

Thanks for any tips,

Simon
This message was edited by sitary on 2002-10-04 15:28

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.
In D2 array-enter & copy down:

=SUBSTITUTE(MCONCAT(IF(\$A\$2:\$A\$5=C2,"; "&\$B\$2:\$B\$5,"")),"; ","",1)

To array-enter a formula, you need to hit control+shift+enter at the same time, not just enter.

http://longre.free.fr/english/index.html

See...
aaConditionalConcat Sitary.xls
ABCD
1ProjectsNotesSummaryReport
2Project1BuiltairplaneProject1Builtairplane;Buildboat
3Project2DrankbeerProject2Drankbeer;Wentbowling
4Project1Buildboat
5Project2Wentbowling
Sheet1

[No message]

That works great - thanks very much.

Simon

Replies
1
Views
181
Replies
0
Views
68
Replies
1
Views
233
Replies
13
Views
689
Replies
4
Views
704

1,217,382
Messages
6,136,234
Members
450,000
Latest member
jgp19

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back