Hello,
I have a parts list, and it shows cut lengths and pieces needed to build a unit. I need some help condensing all duplicates into one line items with total length needed.
the formula would be:
Column B x Column E, and then sum and condense all unique items in column D into one line each, qty 1 with total length of all like units.
I do have other items on these parts lists, screws, fittings, etc. They are all blank in column E, only the planks have a length entered in column E. Column H is the next blank column if that matters at all.
example layout below.
col. a col. b col. c col. d col. e
<colgroup><col span="2"><col><col><col></colgroup><tbody>
</tbody>
the desired output would be:
(col. a) (col. b) (col. c) (col. d) (col. e)
<colgroup><col span="2"><col><col><col></colgroup><tbody>
</tbody>
I have a parts list, and it shows cut lengths and pieces needed to build a unit. I need some help condensing all duplicates into one line items with total length needed.
the formula would be:
Column B x Column E, and then sum and condense all unique items in column D into one line each, qty 1 with total length of all like units.
I do have other items on these parts lists, screws, fittings, etc. They are all blank in column E, only the planks have a length entered in column E. Column H is the next blank column if that matters at all.
example layout below.
col. a col. b col. c col. d col. e
ITEM NO. | QTY. | Description | Part Number | Length[mm] |
1 | 1 | Oak | 04024 | 1346 |
2 | 2 | Oak | 04024 | 1346 |
3 | 2 | Mahogany | 05599 | 1346 |
4 | 1 | Oak | 04024 | 1267 |
5 | 1 | Mahogany | 05599 | 305 |
<colgroup><col span="2"><col><col><col></colgroup><tbody>
</tbody>
the desired output would be:
(col. a) (col. b) (col. c) (col. d) (col. e)
ITEM NO. | QTY. | Description | Part Number | Length[mm] |
1 | 1 | Oak | 04024 | 5305 |
2 | 1 | Mahogany | 05599 | 2997 |
<colgroup><col span="2"><col><col><col></colgroup><tbody>
</tbody>