#1




Formatting Bill of Materials
How can you eliminate duplicates in a bill of materials while also showing the reference designators separated by commas?
The image shows a simple example of what I am after. Starting with the table on the left, how to make it look like the one on the right? Thank you. 
#2




An example how organize data entry and get bill details table for any chosen bill.
Columns in Tables having formulas are colored differently. In case you feel there is no need for users to see some of calculated columns, you can hide them. Some calculated columns are helper columns, and are needed to allow to use SUMIFS()/COUNTIFS() formulas. I used Defined Tables in my example. In Defined Tables (From menu: Insert>Table), formulas and formats are automatically expanded whenever a new row is added (assumed the formula/format remains same for entire column). And whenever you change Table or Column Name, those changes are automatically reflected in all Table formulas over entire workbook. Last edited by ArviLaanemets; 05072021 at 06:12 AM. 
#3




Thanks a lot. Will work on digesting that.

#4




Update the table on the left, then rightclick the table on the right and choose Refresh.
I've assumed a grouping based on Val and Size. 
Thread Tools  
Display Modes  

Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Conversion of Columnwise Bill of Material into Rowwise Bill of Material using Excel Macro VBA  mpapreja  Excel Programming  4  05212018 05:35 AM 
BOM (bill of material)  umairn  Project  1  04172017 02:11 PM 
Integrating Bill Of Materials (BOM)  GRT45  Project  1  03162017 10:26 PM 
Materials/Work Costs Per task  cool28uo  Project  1  02012015 03:59 PM 
Tracking materials over time  Guloluseus  Project  3  04022013 11:08 AM 