Combine Column Cells If Other Col Cells Equal One Another

[HowdeeDoodee]

I need to combine column cells from col D if the row cell values in cols F, G, H are equal. Here is a picture of part of the sheet.

Excel Workbook
	D	E	F	G	H
1	Topic	BkName	BkNumber	ChapNumber	VerseNumber
2	Vanity --- All earthly things are	Eccl	21	1	2
3	Emptiness --- Emptiness Or Vanity Of The Worldly Life --- (Ps 39.11\, 62.9)	Eccl	21	1	2
4	Vanity --- Emptiness Of The Worldly Life --- (Ps 39:11\, 62:9)	Eccl	21	1	2
5	Business Life --- Capital And Labor --- Labor --- Worldly\, Sometimes Disappointing	Eccl	21	1	3
6	Capital and Labor --- Labor --- Worldly\, Sometimes Disappointing	Eccl	21	1	3
7	Fruitless Labor --- (Worldly\, Sometimes Disappointing)	Eccl	21	1	3
8	Toil --- Worldly\, Sometimes Disappointing	Eccl	21	1	3
9	Worldly --- Labor --- Worldly\, Sometimes Disappointing	Eccl	21	1	3
10	Sun --- General References To	Eccl	21	1	5
11	Wind --- Variable nature of	Eccl	21	1	6
12	River --- Run into the sea	Eccl	21	1	7
13	Sea --- Rivers supplied by exhalations from	Eccl	21	1	7
14	Sea --- Replenished by rivers	Eccl	21	1	7
15	Water --- Rises in vapor to the clouds	Eccl	21	1	7
16	Ear --- Not satisfied with earthly things	Eccl	21	1	8
17	Eye --- Not satisfied with seeing	Eccl	21	1	8
18	Emptiness --- Men Unsatisfied\, With Temporal Things --- Opportunities For Seeing And Hearing	Eccl	21	1	8
19	Unsatisfied --- Opportunities For Seeing And Hearing	Eccl	21	1	8
Eccl_John

F2, G2, H2 values = F3, G3, H3 values and so on down the sheet. I want to combine the cell values for D2, D3, and so on down the sheet as long as the column values F, G, H in each row are equal. I want to put the combined cell values into col I right before the cell row values change. In the example shown, D2, D3, D4 would be combined and appear in I4.

Likewise D5, D6, D7, D8, and D9 would be combined and appear in I9...because of the equal values in the cells in F5, F6, F7, F8, and F9

Likewise D12, D13, D14, and D15 would be combined and appear in I15...because of the equal values in the cells in F12, F13, F14, and F15


Thank you in advance for your replies.

 

[John Davis]

I need to combine column cells from col D if the row cell values in cols F, G, H are equal. Here is a picture of part of the sheet.

Excel Workbook
	D	E	F	G	H
1	Topic	BkName	BkNumber	ChapNumber	VerseNumber
2	Vanity --- All earthly things are	Eccl	21	1	2
3	Emptiness --- Emptiness Or Vanity Of The Worldly Life --- (Ps 39.11\, 62.9)	Eccl	21	1	2
4	Vanity --- Emptiness Of The Worldly Life --- (Ps 39:11\, 62:9)	Eccl	21	1	2
5	Business Life --- Capital And Labor --- Labor --- Worldly\, Sometimes Disappointing	Eccl	21	1	3
6	Capital and Labor --- Labor --- Worldly\, Sometimes Disappointing	Eccl	21	1	3
7	Fruitless Labor --- (Worldly\, Sometimes Disappointing)	Eccl	21	1	3
8	Toil --- Worldly\, Sometimes Disappointing	Eccl	21	1	3
9	Worldly --- Labor --- Worldly\, Sometimes Disappointing	Eccl	21	1	3
10	Sun --- General References To	Eccl	21	1	5
11	Wind --- Variable nature of	Eccl	21	1	6
12	River --- Run into the sea	Eccl	21	1	7
13	Sea --- Rivers supplied by exhalations from	Eccl	21	1	7
14	Sea --- Replenished by rivers	Eccl	21	1	7
15	Water --- Rises in vapor to the clouds	Eccl	21	1	7
16	Ear --- Not satisfied with earthly things	Eccl	21	1	8
17	Eye --- Not satisfied with seeing	Eccl	21	1	8
18	Emptiness --- Men Unsatisfied\, With Temporal Things --- Opportunities For Seeing And Hearing	Eccl	21	1	8
19	Unsatisfied --- Opportunities For Seeing And Hearing	Eccl	21	1	8
Eccl_John

F2, G2, H2 values = F3, G3, H3 values and so on down the sheet. I want to combine the cell values for D2, D3, and so on down the sheet as long as the column values F, G, H in each row are equal. I want to put the combined cell values into col I right before the cell row values change. In the example shown, D2, D3, D4 would be combined and appear in I4.

Likewise D5, D6, D7, D8, and D9 would be combined and appear in I9...because of the equal values in the cells in F5, F6, F7, F8, and F9

Likewise D12, D13, D14, and D15 would be combined and appear in I15...because of the equal values in the cells in F12, F13, F14, and F15


Thank you in advance for your replies.

Maybe:

In Column I copied down.

=IF(AND(F2=F3,G2=G3,H2=H3),CONCATENATE(D2,D3),"")

 

[HowdeeDoodee]

Thank you. The formula concatenates only two cells. I need to concatenate a varied number of cells, depending on how many cells in F, G, and H equal one another. For example, after an appropriate macro or formula is run, I4 would contain the values in F2, F3, and F4.

 

[John Davis]

Thank you. The formula concatenates only two cells. I need to concatenate a varied number of cells, depending on how many cells in F, G, and H equal one another. For example, after an appropriate macro or formula is run, I4 would contain the values in F2, F3, and F4.

Sorry that didn't do the trick. This is a bit out of my range, maybe others can help you.

 

[HowdeeDoodee]

Thank you for the honest reply. I ended up using Word macros to solve the issue.