Bill of Materials Matrix

V

Valley

Board Regular
Joined
Aug 30, 2006
Messages
97
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Dear,

I already used variant functionals to get the attached Matrix BOM analysis, who can help to solve per VBA, here thanks in advance!
MultiBOM to MatrixBOM.xlsx
HIKPQR
1Add "SNR"
10NoLevelAL Part NumberVendorComponent informationShort Text
11111307320067SNRZ-DIODE
12221307320067NEXBZX84-C18Z-DIODE
13311307320096SNRDIODE
14411309997049SNRRESISTOR OTHER
15521304503290VISD25-CRCW1206 100 10R0 1% xx e3RESISTOR
16621461001605YAGAC1206FR-xx10RLRESISTOR OTHER
17721304503428KOARK73H2BT..10R0FRESISTOR
18821461000599WALMR12X10R0F_LRESISTOR OTHER
19911309997078SNRRESISTOR OTHER
201021304503296KOARK73H1JT..1002FRESISTOR
211121461001322YAGAC0603FR-xx10KLRESISTOR OTHER
221221461000715WALMR06X1002F_LRESISTOR OTHER
231321304503198VISD11-CRCW0603 100 10k0 1% xx e3RESISTOR
241411309997150SNRRESISTOR OTHER
251521461001559YAGAC0603FR-xx39KLRESISTOR OTHER
261621304503409VISD11-CRCW0603 100 39k0 1% xx e3RESISTOR
271721304503408KOARK73H1JT..3902FRESISTOR
281821461000804WALMR06X3902F_LRESISTOR OTHER
291911309997156SNRCAPACITOR CERAMIC
302021462000183TAYHMK107B7103KAHTCERAMIC-CAPACITOR
312121462000136VISVJ0603Y103KXBA_31XCERAMIC-CAPACITOR
322221307328192TDKCGA3E2X7R2A103KTCERAMIC-CAPACITOR
332321307328194MUTGCM188R72A103KA37DCAPACITOR CERAMIC
342421462000265SAGCL10B103KC85PB_CAPACITOR CERAMIC
352511309997193SNRDIODE DIODE
362621307320105NEXBAS516-QDIODE
372711309997197SNRRESISTOR OTHER
382821304503458VISD11-CRCW0603 100 10R0 1% xx e3RESISTOR
392921304503457KOARK73H1JT..10R0FRESISTOR
403021461001650YAGAC0603FR-xx10RLRESISTOR OTHER
413121461000728WALMR06X10R0F_LRESISTOR OTHER
423211309997280SNRCAPACITOR CERAMIC
433321462000181TAYHMK107B7223KAHTCERAMIC-CAPACITOR
443421307328247MUTGCM188R72A223KA37DCAPACITOR CERAMIC
453521462000261SAGCL10B223KC85PB_CAPACITOR CERAMIC
463621307328248TDKCGA3E2X7R2A223KTCERAMIC-CAPACITOR
473721307328249VISVJ0603Y223KXBA_31CERAMIC-CAPACITOR
483811309997302SNRRESISTOR OTHER
493921304503540KOARK73H1JT..2053FRESISTOR
504021304503544VISD11-CRCW0603 100 205k 1% xx e3RESISTOR
514111309997409SNRRESISTOR OTHER
524221461001019WALMR04X1001F_LRESISTOR OTHER
534321304503647VISCRCW0402 1k00 FK xx E3RESISTOR
544421461001542YAGAC0402FR-xx1KLRESISTOR OTHER
554521304503631KOARK73H1ET..1001FRESISTOR
564611309997411SNRRESISTOR OTHER
574721461000585WALMR04X1002F_LRESISTOR OTHER
584821304503649VISCRCW0402 10K0 FK xx E3RESISTOR
594921461001325YAGAC0402FR-xx10KLRESISTOR OTHER
605021304503619KOARK73H1ET..1002FRESISTOR
615111309997416SNRCAPACITOR CERAMIC
625221462000458SAGCL05C101JB51PB_CAPACITOR CERAMIC
635321462000213VISVJ0402A101JXAA_31XCAPACITOR CERAMIC
645421307328287MUTGCM1555C1H101JA16DCAPACITOR CERAMIC
655521462000091TDKCGA2B2C0G1H101JTCERAMIC-CAPACITOR
665611309997419SNRCAPACITOR CERAMIC
675721462000266VISVJ0402Y332KXBA_31XCAPACITOR CERAMIC
685821307328284MUTGCM155R72A332KA37DCAPACITOR CERAMIC
695921462000098TDKCGA2B3X7S2A332KTCAPACITOR CERAMIC
706011309997422SNRCAPACITOR CERAMIC
716121462000429TAYUMK105 B7103KVH_CAPACITOR CERAMIC
726221307328281MUTGCM155R71H103KA55DCAPACITOR CERAMIC
736321462000083TDKCGA2B3X7R1H103KTCERAMIC-CAPACITOR
746421462000382SAGCL05B103KB54PB_CAPACITOR CERAMIC
756521307328289VISVJ0402Y103KXAA_31CERAMIC-CAPACITOR
766611309997483SNRDIODE DIODE
776721307320147VISS1JHE3_ADIODE DIODE
786811309997488SNRCAPACITOR CERAMIC
796921462000396SAGCL32B475KBJ4PB_CAPACITOR CERAMIC
807021307328298MUTGCM32ER71H475KA55LCERAMIC-CAPACITOR
817121462000067TDKCGA6P3X7R1H475KTCAPACITOR CERAMIC
827221462000316TAYUMK325_B7475KMH_CERAMIC-CAPACITOR
837311309997523SNRRESISTOR OTHER
847421304503790KOARK73H1ET..1962FRESISTOR
857521461000792WALMR04X1962F_LRESISTOR OTHER
867621304503791VISCRCW0402 19k6 FK xx E3RESISTOR
877711309997561SNRCAPACITOR CERAMIC
887821462000100TDKCGA4J3X7R1E225KTCAPACITOR CERAMIC
897921307328328MUTGCM21BR71E225KA73LCERAMIC-CAPACITOR
908011309997585SNRRESISTOR OTHER
918121304503850KOARK73H1ET..3162FRESISTOR
928221304503851VISCRCW0402 31k6 FK xx E3RESISTOR
938321461000795WALMR04X3162F_LRESISTOR OTHER
948421461001642YAGAC0402FR-xx31K6LRESISTOR OTHER
958511309997603SNRINDUCTOR INDUCTOR
968621463000261MUTBLM21SP601SH1DINDUCTOR INDUCTOR
978721307322049TDKMPZ2012S601ATD25INDUCTANCE
988811309997616SNRTRANSISTOR MOSFET
998921307345114ONS2V7002KT1GFET
1009021307345091DIO2N7002KQ-7TRANSISTOR MOSFET
1019111309997699SNRINDUCTOR INDUCTOR
1029221307322056TDKMPZ2012S300ATD25INDUCTANCE
1039321463000263MUTBLM21SN300SH1DINDUCTOR INDUCTOR
1049411309997782SNRCAPACITOR CERAMIC
1059521462000390SAGCL10B104KB8VPF_CAPACITOR CERAMIC
1069621307328375TDKCGA3E2X7R1H104KT***SCERAMIC-CAPACITOR
1079721462000073MUTGCJ188R71H104KA12DCAPACITOR CERAMIC
1089811309997985SNRCAPACITOR CERAMIC
1099921307328392TDKCGA2B2C0G1H470JTCERAMIC-CAPACITOR
11010021462000304VISVJ0402A470JXAA_31XCAPACITOR CERAMIC
11110121307328393MUTGCM1555C1H470JA16DCERAMIC-CAPACITOR
11210211460000223SNRLED
11310321460000223OOSLA E67F-CADA-24-3A5ALED
11410411466000036SNRCAPACITOR CERAMIC
11510521462000161TAYUMK316AC7475KLHTECERAMIC-CAPACITOR
11610621462000032TDKCGA5L3X7R1H475KTCAPACITOR CERAMIC
11710721462000267SAGCL31B475KBHVPB_CAPACITOR CERAMIC
11810821462000033MUTGCM31CC71H475KA03LCAPACITOR CERAMIC
11910911466000042SNRDIODE DIODE
12011021465000002NEXBZX585-C4V7Z-DIODE
12111121465000001ONSSZMM5Z4V7T1GZ-DIODE
12211211466000066SNRDIODE DIODE
12311321465000261TSCP6SMB27CAHDIODE DIODE
12411421465000009VISP6SMB27CAHE3_ADIODE DIODE
12511511466000096SNRRESISTOR OTHER
12611621461000037VISCRCW0402 4k70 FK xx E3RESISTOR
12711721461000035KOARK73H1ET..4701FRESISTOR
12811821461000810WALMR04X4701F_LRESISTOR OTHER
12911921461001553YAGAC0402FR-xx4K7LRESISTOR OTHER
13012011466000122SNRINDUCTOR INDUCTOR
13112121463000010TAYNRS6045T6R3MMGKVINDUCTANCE
13212211466000199SNRRESISTOR OTHER
13312321461000112KOARK73H1ET..1302FRESISTOR
13412421461001492WALMR04X1302F_LRESISTOR OTHER
13512521461000113VISCRCW0402 13k0 FK xx E3RESISTOR OTHER
13612611466000243SNRCAPACITOR CERAMIC
13712721462000211TAYEMK325_B7226KMH_CAPACITOR CERAMIC
13812821462000055TDKCGA6P1X7R1C226MTCAPACITOR CERAMIC
13912921462000395SAGCL32B226KOJVPB_CAPACITOR CERAMIC
14013021462000054MUTGCM32ER71C226KE19LCERAMIC-CAPACITOR
14113111466000511SNRRESISTOR OTHER
14213221461000445VISCRCW1206 4R70 FK xxe3RESISTOR
14313321461001371WALMR12W4R70F_LRESISTOR OTHER
14413421461000494KOARK73H2BT..4R70FRESISTOR
14513511466000575SNRTRANSISTOR BIPOLAR
14613621465000136NEXBC846BW-QBIP_TRANSISTOR
14713721465000101ONSSBC846BWT1GBIP_TRANSISTOR
14813811466000611SNRDIODE DIODE
14913921465000115ONSSZBZX84B6V2LT_GZ-DIODE
15014021465000114NEXBZX84-B6V2Z-DIODE
15114121465000329VISBZX84B6V2-HE3DIODE DIODE
15214211466000614SNRRESISTOR OTHER
15314321461000554VISCRCW0603110kFKxxe3RESISTOR OTHER
15414421461001248WALMR06X1103F_LRESISTOR OTHER
15514521461000553KOARK73H1JT..1103FRESISTOR OTHER
15614611466000629SNRDIODE DIODE
15714721465000122VISS2JHE3_ADIODE DIODE
15814811466000635SNRDIODE DIODE
15914921465000123NEXBAS16-QDIODE DIODE
16015021465000124ONSSBAS16LT_GDIODE DIODE
16115111466000720SNRINTEGRATED_CIRCUIT OTHER
16215221464000097TITPS92630QPWPRQ1INTEGRATED_CIRCUIT OTHER
16315311466000744SNRRESISTOR OTHER
16415421466000744SNRDummyRESISTOR+SNR
16515511466000761SNRRESISTOR OTHER
16615621466000761SNRDummyRESISTOR+SNR
16715711466000811SNRRESISTOR OTHER
16815821461000609VISCRCW0402 200K FK xx E3RESISTOR
16915921461001459WALMR04X2003FRESISTOR OTHER
17016021461000608KOARK73H1ET..2003FRESISTOR OTHER
17116111466000947SNRRESISTOR OTHER
17216221461001194WALMR04X1472F_LRESISTOR OTHER
17316321461001546YAGAC0402FR-xx14K7LRESISTOR OTHER
17416421461001192KOARK73H1ET..1472FRESISTOR OTHER
17516521461001193VISCRCW0402 14k7 FK xx E3RESISTOR
17616611466001011SNRCAPACITOR CERAMIC
17716721462000162TAYUMK325AB7106KMHPCERAMIC-CAPACITOR
17816821462000163TDKCGA6P3X7S1H106KTCERAMIC-CAPACITOR
17916921462000164MUTGCM32EC71H106KA03LCAPACITOR CERAMIC
18017011466001354SNRCAPACITOR CERAMIC
18117121462000087MUTGCM155R71H104KE02DCAPACITOR CERAMIC
18217221462000206TDKCGA2B3X7R1H104KTCERAMIC-CAPACITOR
18317311466001356SNRLED+SNR
18417421466001356OOSKR DMLQ31.23-JZKY-24-J3T3LED
18517511466001421SNRRESISTOR OTHER
18617621304503189VISD11-CRCW0603 0R0 xx e3RESISTOR
18717721304503435KOARK73Z1JTRESISTOR
18817811466001430SNRRESISTOR OTHER
18917921461000933WALMR04X4022F_LRESISTOR OTHER
19018021461000931KOARK73H1ET..4022FRESISTOR OTHER
19118121461000932VISCRCW0402 40k2 FK xx E3RESISTOR
19218211466001431SNRRESISTOR OTHER
19318321461001749YAGAC0402FR-xx28KLRESISTOR OTHER
19418421461000937KOARK73H1ET..2802FRESISTOR OTHER
19518521461000939WALMR04X2802F_LRESISTOR OTHER
19618621461000938VISCRCW0402 28k0 FK xx E3RESISTOR
19718711466001870SNRINDUCTOR INDUCTOR
19818821463000187VISIHLP3232DZER150M5AINDUCTOR INDUCTOR
19918911466002081SNRDIODE DIODE
20019021465000360NEXBZX585-C6V8DIODE DIODE
MultiBOM toCombo
 

Attachments

  • vtbom.GIF
    vtbom.GIF
    93.6 KB · Views: 18
  • vtmbom.GIF
    vtmbom.GIF
    137.9 KB · Views: 19

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
Sort by date Sort by votes
What does BOM mean? Remember not everyone understands those acronyms. Thx
 
Upvote 0
Dear,

here above "BOM" that is the list of materials, and I want to convert picture 1 to picture 2 if possible
 

Attachments

  • picture 1.GIF
    picture 1.GIF
    137.9 KB · Views: 15
  • picture 2.GIF
    picture 2.GIF
    93.6 KB · Views: 16
Upvote 0
arthurbr said:
What does BOM mean?
Click to expand...
Good question.

arthurbr said:
Remember not everyone understands those acronyms.
Click to expand...
.. and even some of those those that think they do are clearly wrong, as BOM where I come from commonly means "Bureau of Meteorology"

@Valley
Apart from clarifying the above point, I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)
 
Upvote 0
Valley said:
ok, how to change the title?:ROFLMAO::ROFLMAO::ROFLMAO:
Click to expand...
You can't. Normally, if you need that (we are generally reluctant to change thread titles) then click the 'Report' button under the first post and explain what you want changed and why.
In this case I have changed it.

Regardless of the title, I don't understand what you are wanting. Since nobody else has replied with a suggestion either, I suspect that is case for all of the nearly 40 'views' the thread has had.
I suggest that you reply again and try to spell out in with more clarity
- what you are starting with
- what you want to finish with
- what is the process/logic to get from start to finish
 
Upvote 0
Peter_SSs said:
You can't. Normally, if you need that (we are generally reluctant to change thread titles) then click the 'Report' button under the first post and explain what you want changed and why.
In this case I have changed it.

Regardless of the title, I don't understand what you are wanting. Since nobody else has replied with a suggestion either, I suspect that is case for all of the nearly 40 'views' the thread has had.
I suggest that you reply again and try to spell out in with more clarity
- what you are starting with
- what you want to finish with
- what is the process/logic to get from start to finish
Click to expand...
ok, maybe it is complex issue, I would close this topic, and I try to simple figure out to my require, thanks agian.
 
Upvote 0
You must log in or register to reply here.

Similar threads

K
  • Question
Array SUM or SUMPRODUCT function error
Replies
1
Views
229
KratosZG
K
A
  • Question
Multi-level Bill Of Materials explosion
3 4 5
Replies
40
Views
3K
Andy Howcroft
A
S
  • Solved
Determine which products are made of the exact same set of materials
Replies
8
Views
790
Sajinjs
S
R
  • Question
Updating Parent part system to all child parts
Replies
3
Views
563
Peter_SSs
Peter_SSs
E
  • Question
Return a bill of material that's created on another sheet without any lines that = 0
Replies
1
Views
335
Jamie McMillan
J

Forum statistics

Threads
1,214,918
Messages
6,122,241
Members
449,075
Latest member
staticfluids

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top