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