Find all Models of Printers Using the Same Part Number

M

meppwc

Well-known Member
Joined
May 16, 2003
Messages
604
Office Version
  1. 365
Platform
  1. Windows
I have no idea how to accomplish this but I suspect it is possible.
In column A I have a unique list of printer models
In column C I have ink part numbers that fit each of those machines. These part numbers appear numerous times in column C because any particular part may fit numerous machines found in column A.

I am hoping that there is a way to list each part number from column C, accompanied with all models of machines from column A that apply.
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
Sort by date Sort by votes
I am sorry. I do not know what an XL2BB is or how to create and post it. Can you advise?
 
Upvote 0
BJC - Asset_List 11.24.20.xlsx
ABC
1Model NumberAsset TypeBlack
2XM5170Mono Print24B6015
3XC4150Mono Print24B6015
4X656deMono PrintT650H21A
5X511deMono Print
6X466deMono PrintX463X21G
7X364dnMono PrintX264A11G
8X204nMono PrintX203A21G
9WorkCentre 4250Mono Print106R01408
10WorkCentre 6505COLOR PRINT
11WorkCentre 3655Mono MFD
12WorkCentre 3325Mono Print106R2311
13WorkCentre 3210Mono Print106R01486
14VersaLink C400Color Print106R03512
15VersaLink C505COLOR PRINT106R03862
16T654dnMono PrintT650H21A
17T654Mono PrintT650H21A
18T652dnMono PrintT650H21A
19T650nMono PrintT650H21A
20T644Mono Print64015HA
21T640nMono Print64015HA
22T632Mono Print
23SPC342DNColor Print406475
24SP5210SR-RICMono Print406683
25SP4100NMono Print402809
26SP3500SFMono Print
27SCX-4623FMono PrintMLT-D105L
28PSC 950xiMONO PRINTCN045AN
29Pixma TR8520Color Print
30PIXMA MX340Color Print2973B001
31PIXMA MP830Color Print0620B002
32PIXMA iP3600Color Print2946B001
33PhotoSmart D110aColor PrintCC641WN
34PhotoSmart C4680Color PrintCC640WN
35Phaser 6700Color Print
36Phaser 6600COLOR PRINT
37Phaser 6500COLOR PRINT
38Phaser 6360DNCOLOR PRINT
39Phaser 6300COLOR PRINT106R1085
40Phaser 6280COLOR PRINT
41Phaser 6180COLOR PRINT
42Phaser 6130nCOLOR PRINT106R1281
43Phaser 6010COLOR PRINT106R1630
44Phaser 5550Mono Print106R1294
45Phaser 5500Mono Print113R668
46Phaser 5400Mono Print113R495
47Phaser 4622Mono Print106R1533
48Phaser 4620Mono Print106R1533
49Phaser 4600Mono Print106R1533
50Phaser 4510NMono Print113R711
51Phaser 4510DTMono Print113R711
52Phaser 4510Mono Print
53Phaser 4500Mono Print
54Phaser 4400Mono Print113R628
55Phaser 3635Mono MFP
56Phaser 3610Mono Print
57Phaser 3600Mono Print
58Phaser 3500NMono Print106R01149
59Phaser 3250Mono Print106R1374
60Phaser 3150Mono Print109R747
61Panafax DX-800FaxUG5510
62Panafax UF-8200FaxUG-5570
63Panafax Uf-8000FaxUG5540
64Panafax UF-7950FaxUG5550
65Panafax UF-770FaxUG3313
66Panafax UF-6200FaxUG5580
67Panafax DX-2000FaxUG3313
68Optra S1250Mono Print1382620
69OfficeJet Pro 8730Color Print
70OfficeJet 9020Color Print
71OfficeJet 9010Color Print
72OfficeJet 8730Color Print
73OfficeJet 8720Color Print
74OfficeJet 8710Color Print
75OfficeJet 8600Color Print
76OfficeJet 8210Color Print
77OfficeJet 8100Color PrintCN045AN
78OfficeJet 6600Color Print
79OfficeJet 6230Color Print
80MX711deMono Print62D1000
81MX711Mono Print62D1000
82MX511deMono Print
83MS825dnMono Print
84MS823dnMono Print
85MS815dnMono Print52D1000
86MS812dnMono Print52D1H00
87MS812Mono Print52D1H00
88MS811dnMono Print52D1H00
89MS811Mono Print52D1H00
90MS810nMono Print52D1H00
91MS810dnMono Print52D1H00
92MS810Mono Print52D1H00
93MS725Mono Print
94MS710dnMono Print
95MS610dnMono Print50F1X00
96MS510dnMono Print50F1X00
97MS415dnMono Print50F1X00
98MS415Mono Print50F1X00
99MS410dnMono Print50F1X00
100MS321Mono Print56F1000
101MS315dnMono Print50F1X00
102MS312nMono Print50F1X00
103MS312dnMono Print50F1X00
104MS310dnMono Print50F1X00
105MS310Mono Print50F1X00
106MPC307Color MFD842091
107MP6503SPMono MFD885400
108ML-3750NDMono PrintMLT-D305L
109ML-3750Mono PrintMLT-D305L
110MFC-J825DWMono Print
111MFC-J470DWMono Print
112MFC-9700Mono Print
113MFC-9340cdwMono PrintTN221BK
114MFC-9320cwMono PrintTN210BK
115MFC-8950dwMono Print
116MFC-8460nMono Print
117MFC-8220Mono Print
118MFC-8120Mono Print
119MFC-7860DWMono Print
120MFC-7840wMono Print
121MFC-7440NMono Print
122MFC-7420Mono Print
123MFC-7365DNMono Print
124MFC-7240Mono Print
125MFC-7220Mono Print
126MFC-6490cwMono Print
127MFC-5490cnMono Print
128MFC-4800Mono PrintTN200
129MC3326Mono PrintC3210K0
130M811Mono Print52D0HA0
131Laserjet P2035Mono PrintCE505A
132LaserJet M528Mono Print
133LaserJet M1536dnfMono PrintCE278A
134LaserJet M1212nfMono PrintCE285A
135LaserJet M102Mono PrintCF217A
136LaserJet CM1415fnwColor PrintCE320A
137LaserJet 1022Mono PrintQ2612A
138LaserJet Pro M201Mono PrintCF283A
139LaserJet Pro M1212nfMono PrintCE285A
140LaserJet Pro M102wMono PrintCF217A
141LaserJet P4515tnMono PrintCC364A
142LaserJet P4515nMono PrintCC364A
143LaserJet P4515Mono PrintCC364A
144LaserJet P4015Mono PrintCC364A
145LaserJet P4014Mono PrintCC364A
146LaserJet P3015Mono PrintCE255A
147LaserJet P3005Mono Print
148LaserJet P2055Mono PrintCE505A
149LaserJet P2035Mono PrintCE505A
150LaserJet P2015Mono PrintQ7553A
151LaserJet P1606dnMono PrintCE278A
152LaserJet P1505Mono PrintCB436A
153LaserJet P1102WMono PrintCE285A
154LaserJet p1006Mono PrintCB435A
155LaserJet P1005Mono PrintCB435A
156LaserJet M806dnMono Print
157LaserJet M630Mono PrintCF281A
158LaserJet M608Mono PrintCF237A
159LaserJet M607Mono PrintCF237A
160LaserJet M606Mono PrintCF281A
161LaserJet M605Mono PrintCF281A
162LaserJet M604Mono PrintCF281A
163LaserJet M603Mono PrintCE390A
164LaserJet M602Mono PrintCE390A
165LaserJet M601Mono PrintCE390A
166LaserJet M528Mono Print
167LaserJet M527Mono PrintCF287A
168LaserJet M525Mono PrintCE255A
169LaserJet M521dnMono PrintCE255A
170LaserJet M507Mono Print
171LaserJet M506Mono PrintCF287A
172LaserJet M501Mono PrintCF287A
173LaserJet M4555Mono PrintCE390A
174LaserJet M4345Mono Print
175LaserJet M428fdnMono PrintCF258A
176LaserJet M428Mono PrintCF258A
177LaserJet M426fdwMono PrintCF226A
178LaserJet M426fdnMono PrintCF226A
179LaserJet M426Mono PrintCF226A
180LaserJet M425dnMono Print
181LaserJet M425Mono Print
182LaserJet M404Mono PrintCF258A
183LaserJet M402Mono PrintCF226A
184LaserJet M401Mono Print
185LaserJet M2727nfMono Print
186LaserJet M225dnMono PrintCF283A
187LaserJet M1522NFMono PrintCB436A
188LaserJet M130fnMono PrintCF217A
189LaserJet M102wMono PrintCF217A
190LaserJet 9050Mono Print
191LaserJet 8150Mono PrintC4182X
192LaserJet 8100Mono PrintC4182X
193LaserJet 8000Mono Print
194LaserJet 5nMono Print92298A
195LaserJet 5100Mono PrintC4129X
196LaserJet 4350Mono PrintQ5942A
197LaserJet 4300Mono PrintQ5942A
198LaserJet 4250Mono PrintQ5942A
199LaserJet 4240nMono PrintQ5942A
200LaserJet 4200Mono Print
201LaserJet 4100Mono Print
202LaserJet 4050Mono Print
203LaserJet 4000Mono Print
204LaserJet 400 M401Mono Print
205LaserJet 3055Mono Print
206LaserJet 2430Mono Print
207LaserJet 1320Mono PrintQ5949A
208LaserJet 1300Mono Print
209LaserJet 1200Mono Print
210LaserJet 1022Mono PrintQ2612A
211LaserJet 1012Mono PrintQ2612A
212KX-FL511FaxKXFA83
213KX-FHD351FaxKXFA93
214IntelliFax-5750eFaxTN460
215IntelliFax 4750FaxTN460
216IntelliFax 4100eFaxTN460
217IntelliFax 2940FaxTN450
218IntelliFax 2920FaxTN350
219IntelliFax 2840FaxTN450
220IntelliFax 2820FaxTN350
221Intellifax 1860CFaxLC51BK
222IntelliFax 1270FaxTN460
223IMC6000Color MFD842279
224IMC4500Color MFD842279
225IMC300FColor MFD 842378
226IMC3000Color MFD842251
227IMC2000Color MFD842307
228IM550Mono MFD418477
229IM350Mono MFD418132
230HL-L6200DWMono PrintTN850
231HL-L5000dMono PrintTN850
232HL-L2370nwMono PrintTN760
233HL-L2370Mono PrintTN760
234HL-L2360Mono PrintTN660
235HL-L2340DMono PrintTN660
236HL-5540DMono Print
Part#s
 
Upvote 0
Which version of Excel do you run? If 365, I think this solution will work:
Cell D2:
Code: 
=UNIQUE(FILTER(C2:C236,C2:C236<>""))
provides the unique ink part numbers
E2:
Code: 
=TRANSPOSE(FILTER($A$2:$A$236,D2=$C$2:$C$236))
filled down provides a list in each row of the Models.
 
Upvote 0
That worked perfectly. Thank you so much
 
Upvote 0
You must log in or register to reply here.

Similar threads

rjplante
  • Solved
Change from Set as Default to Set as Active printer
Replies
1
Views
199
NdNoviceHlp
NdNoviceHlp
C
  • Question
Comparing 3 tables to a list of numbers, if match, return 4 columns worth of data on another tab
Replies
4
Views
67
alansidman
A
2
  • Question
Using Barcode and Data Validation List to Prevent Errors
Replies
4
Views
233
2KGrafix
2
C
  • Question
Determine Points per Selection Based on Rank and Number of Selections
Replies
1
Views
47
awoohaw
awoohaw
A
  • Solved
#REF! error when using INDEX MATCH
Replies
5
Views
80
Fluff
Fluff

Forum statistics

Threads
1,214,622
Messages
6,120,572
Members
448,972
Latest member
Shantanu2024

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