Combine Column Cells If Other Col Cells Equal One Another

HowdeeDoodee

Well-known Member
Joined
Nov 15, 2004
Messages
596
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
DEFGH
1TopicBkNameBkNumberChapNumberVerseNumber
2Vanity --- All earthly things areEccl2112
3Emptiness --- Emptiness Or Vanity Of The Worldly Life --- (Ps 39.11\, 62.9)Eccl2112
4Vanity --- Emptiness Of The Worldly Life --- (Ps 39:11\, 62:9)Eccl2112
5Business Life --- Capital And Labor --- Labor --- Worldly\, Sometimes DisappointingEccl2113
6Capital and Labor --- Labor --- Worldly\, Sometimes DisappointingEccl2113
7Fruitless Labor --- (Worldly\, Sometimes Disappointing)Eccl2113
8Toil --- Worldly\, Sometimes DisappointingEccl2113
9Worldly --- Labor --- Worldly\, Sometimes DisappointingEccl2113
10Sun --- General References ToEccl2115
11Wind --- Variable nature ofEccl2116
12River --- Run into the seaEccl2117
13Sea --- Rivers supplied by exhalations fromEccl2117
14Sea --- Replenished by riversEccl2117
15Water --- Rises in vapor to the cloudsEccl2117
16Ear --- Not satisfied with earthly thingsEccl2118
17Eye --- Not satisfied with seeingEccl2118
18Emptiness --- Men Unsatisfied\, With Temporal Things --- Opportunities For Seeing And HearingEccl2118
19Unsatisfied --- Opportunities For Seeing And HearingEccl2118
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.
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

John Davis

Well-known Member
Joined
Sep 11, 2007
Messages
3,457
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
DEFGH
1TopicBkNameBkNumberChapNumberVerseNumber
2Vanity --- All earthly things areEccl2112
3Emptiness --- Emptiness Or Vanity Of The Worldly Life --- (Ps 39.11\, 62.9)Eccl2112
4Vanity --- Emptiness Of The Worldly Life --- (Ps 39:11\, 62:9)Eccl2112
5Business Life --- Capital And Labor --- Labor --- Worldly\, Sometimes DisappointingEccl2113
6Capital and Labor --- Labor --- Worldly\, Sometimes DisappointingEccl2113
7Fruitless Labor --- (Worldly\, Sometimes Disappointing)Eccl2113
8Toil --- Worldly\, Sometimes DisappointingEccl2113
9Worldly --- Labor --- Worldly\, Sometimes DisappointingEccl2113
10Sun --- General References ToEccl2115
11Wind --- Variable nature ofEccl2116
12River --- Run into the seaEccl2117
13Sea --- Rivers supplied by exhalations fromEccl2117
14Sea --- Replenished by riversEccl2117
15Water --- Rises in vapor to the cloudsEccl2117
16Ear --- Not satisfied with earthly thingsEccl2118
17Eye --- Not satisfied with seeingEccl2118
18Emptiness --- Men Unsatisfied\, With Temporal Things --- Opportunities For Seeing And HearingEccl2118
19Unsatisfied --- Opportunities For Seeing And HearingEccl2118
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

Well-known Member
Joined
Nov 15, 2004
Messages
596
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

Well-known Member
Joined
Sep 11, 2007
Messages
3,457
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

Well-known Member
Joined
Nov 15, 2004
Messages
596
Thank you for the honest reply. I ended up using Word macros to solve the issue.
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,409
Messages
5,511,177
Members
408,828
Latest member
Csmnvld

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top