1 ...3456789101112... 19
返回列表 上一主題 發帖

[發問] 多條件篩選&ListBox

c_c_lai

帖子
2035 
主題
24 
精華
0 
積分
2031 
點名
0  
作業系統
Win7 
軟體版本
Office2010 
閱讀權限
100 
性別
男 
註冊時間
2012-3-22 
最後登錄
2024-2-1 
41# 跳轉到 »
發表於 2016-12-1 05:17 | 只看該作者
本帖最後由 c_c_lai 於 2016-12-1 08:44 編輯

回復 40# starbox520
剝絲抽繭，真難怪會沒人回應！
依妳目前之案例，光只是第 1 種 選項， 能通過條件的資料錄有哪幾筆？
能否麻煩一一指出？

TOP

starbox520

帖子
192 
主題
15 
精華
0 
積分
194 
點名
0  
作業系統
windows 
軟體版本
office2010 
閱讀權限
20 
性別
女 
註冊時間
2016-9-22 
最後登錄
2020-8-28 

論壇榮譽勳章論壇贊助勳章
42#
發表於 2016-12-1 09:07 | 只看該作者
回復 41# c_c_lai


    C大，每一種都有可能發生，因為每天"材料"和"工作表2"的資訊都會更新!!!

TOP

c_c_lai

帖子
2035 
主題
24 
精華
0 
積分
2031 
點名
0  
作業系統
Win7 
軟體版本
Office2010 
閱讀權限
100 
性別
男 
註冊時間
2012-3-22 
最後登錄
2024-2-1 
43#
發表於 2016-12-1 11:38 | 只看該作者
回復 42# starbox520
不是每天，單純地光只是目前，
僅以第 1 種 選項， 能通過條件的比對到 "工作表2" 資料錄的有哪幾筆？
能否麻煩一一指出？
這是我以 第 1 種 選項 Debug 程式得出的結果，無一比對成功 ( "工作表2")
SYNAPTICS, BGA, 17.3X7, 36
Arr(1)(0)=SHK, SYNAPTICS
Arr(2)(0)=VSK, SYNAPTICS
Ar2(1)(0)=VSK, BGA, 17.3X7, 36, 4102508111
Ar2(2)(0)=VSK, BGA, 17.3X7, 36, 4102079111

ATMEL, CBGA, 9X9, 196
Arr(1)(0)=ACS, ATMEL
Arr(2)(0)=ATM, ATMEL
Arr(3)(0)=ES2, ATMEL
Arr(4)(0)=EUR, ATMEL
Arr(5)(0)=MRS, ATMEL
Arr(6)(0)=NPM, ATMEL

ASMEDIA TECH., QFN, 9X9, 64
Arr(1)(0)=ASM, ASMEDIA TECH.
Ar2(1)(0)=ASM, QFN, 9X9, 64, 4100998111
Ar3(1)(0)=ATI, QFN, 9X9, 64, 4100998111

HUAWEI, VFBGA, 12.2X12.2, 845
Arr(1)(0)=HUW, HUAWEI

ASMEDIA TECH., QFN, 6X6, 48
Arr(1)(0)=ASM, ASMEDIA TECH.
Ar2(1)(0)=ASM, QFN, 6X6, 48, 4100655112

SYNAPTICS, BGA, 17.3X7, 36
Arr(1)(0)=SHK, SYNAPTICS
Arr(2)(0)=VSK, SYNAPTICS
Ar2(1)(0)=VSK, BGA, 17.3X7, 36, 4102508111
Ar2(2)(0)=VSK, BGA, 17.3X7, 36, 4102079111

QUALCOMM, BGA, 14X12, 821
Arr(1)(0)=QCM, QUALCOMM
Ar2(1)(0)=QCM, BGA, 14X12, 821, 4101880111
Ar3(1)(0)=QCM, BGA, 12X14, 792, 4101880111
Ar3(2)(0)=QCM, BGA, 12X14, 720, 4101880111
Ar3(3)(0)=QCM, BGA, 12X14, 727, 4101880111
Ar3(4)(0)=QCM, BGA, 12X14, 760, 4101880111

HUAWEI, VFBGA, 4.5X5, 124
Arr(1)(0)=HUW, HUAWEI

QUALCOMM, TFBGA, 9X9, 0
Arr(1)(0)=QCM, QUALCOMM

ATMEL, TQFP, 14X14, 100
Arr(1)(0)=ACS, ATMEL
Arr(2)(0)=ATM, ATMEL
Arr(3)(0)=ES2, ATMEL
Arr(4)(0)=EUR, ATMEL
Arr(5)(0)=MRS, ATMEL
Arr(6)(0)=NPM, ATMEL
Ar2(1)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar2(2)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar2(3)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar2(4)(0)=ATM, TQFP, 14X14, 100, 4101312111
Ar3(1)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(2)(0)=ATM, TQFP, 14X14, 64, 4101149111
Ar3(3)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(4)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(5)(0)=ATM, TQFP, 14X14, 64, 4101149111
Ar3(6)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(7)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(8)(0)=ATM, TQFP, 14X14, 64, 4101149111
Ar3(9)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(10)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(11)(0)=ATM, TQFP, 14X14, 64, 4101149111
Ar3(12)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(13)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(14)(0)=ATM, TQFP, 14X14, 64, 4101149111
Ar3(15)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(16)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(17)(0)=ATM, TQFP, 14X14, 64, 4101149111
Ar3(18)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(19)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(20)(0)=ATM, TQFP, 14X14, 64, 4101149111
Ar3(21)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(22)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(23)(0)=ATM, TQFP, 14X14, 64, 4101149111
Ar3(24)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(25)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(26)(0)=ATM, TQFP, 14X14, 64, 4101149111
Ar3(27)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar2(5)(0)=MRS, TQFP, 14X14, 100, 4101149111
Ar2(6)(0)=MRS, TQFP, 14X14, 100, 4101149111
Ar3(28)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(29)(0)=ATM, TQFP, 14X14, 64, 4101149111
Ar3(30)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(31)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(32)(0)=ATM, TQFP, 14X14, 64, 4101149111
Ar3(33)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(34)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(35)(0)=ATM, TQFP, 14X14, 64, 4101149111
Ar3(36)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(37)(0)=ATM, TQFP, 14X14, 64, 4101149111
Ar3(38)(0)=ATM, TQFP, 14X14, 64, 4101149111
Ar3(39)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(40)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(41)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(42)(0)=ATM, TQFP, 14X14, 64, 4101149111
Ar3(43)(0)=ATM, TQFP, 14X14, 64, 4101149111
Ar3(44)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(45)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(46)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(47)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(48)(0)=ATM, TQFP, 14X14, 64, 4101149111
Ar3(49)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(50)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(51)(0)=ATM, TQFP, 14X14, 64, 4101149111
Ar3(52)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(53)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(54)(0)=ATM, TQFP, 14X14, 64, 4101149111
Ar3(55)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(56)(0)=ATM, TQFP, 14X14, 64, 4101149111
Ar3(57)(0)=ATM, TQFP, 14X14, 64, 4101149111
Ar3(58)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(59)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(60)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(61)(0)=ATM, TQFP, 14X14, 64, 4101149111
Ar3(62)(0)=ATM, TQFP, 14X14, 64, 4101149111
Ar3(63)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(64)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(65)(0)=ATM, TQFP, 14X14, 100, 4101149111

HUAWEI, VFBGA, 5.8X5.1, 134
Arr(1)(0)=HUW, HUAWEI
Ar2(1)(0)=HUW, VFBGA, 5.8X5.1, 134, 4102461111
Ar3(1)(0)=HUW, VFBGA, 5.8X5.1, 134, 4102461111

M.T.K., VFBGA, 7X7, 112
Arr(1)(0)=UM9, M.T.K.

QUALCOMM, BGA, 6.2X6.2, 176
Arr(1)(0)=QCM, QUALCOMM
Ar2(1)(0)=QCM, BGA, 6.2X6.2, 176, 4101862111

TOP

c_c_lai

帖子
2035 
主題
24 
精華
0 
積分
2031 
點名
0  
作業系統
Win7 
軟體版本
Office2010 
閱讀權限
100 
性別
男 
註冊時間
2012-3-22 
最後登錄
2024-2-1 
44#
發表於 2016-12-1 11:39 | 只看該作者
回復 42# starbox520
HUAWEI, VFBGA, 4.5X5, 124
Arr(1)(0)=HUW, HUAWEI

M.T.K., QFN, 5X5, 40
Arr(1)(0)=UM9, M.T.K.
Ar2(1)(0)=UM9, QFN, 5X5, 40, 4100291111
Ar3(1)(0)=POW, QFN, 5X5, 32, 4100291111
Ar3(2)(0)=POW, QFN, 5X5, 40, 4100291111
Ar3(3)(0)=POW, QFN, 5X5, , 4100291111
Ar3(4)(0)=POW, QFN, 5X5, 32, 4100291111
Ar3(5)(0)=POW, QFN, 5X5, , 4100291111
Ar3(6)(0)=POW, QFN, 5X5, 32, 4100291111
Ar3(7)(0)=POW, QFN, 5X5, 36, 4100291111
Ar3(8)(0)=POW, QFN, 5X5, 44, 4100291111
Ar3(9)(0)=POW, QFN, 5X5, 32, 4100291111
Ar3(10)(0)=POW, QFN, 5X5, 40, 4100291111
Ar3(11)(0)=POW, QFN, 5X5, 40, 4100291111

QUALCOMM, BGA, 8.6X8.4, 443
Arr(1)(0)=QCM, QUALCOMM
Ar2(1)(0)=QCM, BGA, 8.6X8.4, 443, 4102051111

HUAWEI, VFBGA, 12.2X12.2, 0
Arr(1)(0)=HUW, HUAWEI

SYNAPTICS, BGA, 17.3X7, 147
Arr(1)(0)=SHK, SYNAPTICS
Arr(2)(0)=VSK, SYNAPTICS

SYNAPTICS, BGA, 17.3X7, 36
Arr(1)(0)=SHK, SYNAPTICS
Arr(2)(0)=VSK, SYNAPTICS
Ar2(1)(0)=VSK, BGA, 17.3X7, 36, 4102508111
Ar2(2)(0)=VSK, BGA, 17.3X7, 36, 4102079111

QUALCOMM, BGA, 12X14, 760
Arr(1)(0)=QCM, QUALCOMM
Ar2(1)(0)=QCM, BGA, 12X14, 760, 4101880111
Ar3(1)(0)=QCM, BGA, 14X12, 821, 4101880111

QUALCOMM, BGA, 12X14, 727
Arr(1)(0)=QCM, QUALCOMM
Ar2(1)(0)=QCM, BGA, 12X14, 727, 4101880111
Ar3(1)(0)=QCM, BGA, 14X12, 821, 4101880111

QUALCOMM, TFBGA, 10X10, 873
Arr(1)(0)=QCM, QUALCOMM

M.T.K., VFBGA, 13X13.4, 873
Arr(1)(0)=UM9, M.T.K.
Ar2(1)(0)=UM9, VFBGA, 13X13.4, 873, 4102319111

QUALCOMM, BGA, 12X14, 727
Arr(1)(0)=QCM, QUALCOMM
Ar2(1)(0)=QCM, BGA, 12X14, 727, 4101880111
Ar3(1)(0)=QCM, BGA, 14X12, 821, 4101880111

QUALCOMM, BGA, 6.2X6.2, 176
Arr(1)(0)=QCM, QUALCOMM
Ar2(1)(0)=QCM, BGA, 6.2X6.2, 176, 4101862111

BROADCOM, WFBGA, 2.8X2.8, 100
Arr(1)(0)=NCI, BROADCOM
Arr(2)(0)=NCI, BROADCOM
Arr(3)(0)=NCI, BROADCOM

KING YUAN, VFBGA, 6.6X6.6, 205
Arr(1)(0)=KYE, KING YUAN
Arr(2)(0)=KYE, KING YUAN
Ar2(1)(0)=KYE, VFBGA, 6.6X6.6, 205, 4100997111
Ar3(1)(0)=SON, VFBGA, 6.5X6.5, 185, 4100997111
Ar3(2)(0)=SON, TFBGA, 6.5X6.5, 64, 4100997111
Ar3(3)(0)=SON, VFBGA, 6.5X6.5, , 4100997111
Ar3(4)(0)=SON, BGA, 6.5X6.5, 64, 4100997111
Ar3(5)(0)=SON, BGA, 6.5X6.5, 72, 4100997111
Ar3(6)(0)=SON, BGA, 6.5X6.5, 112, 4100997111
Ar2(2)(0)=KYE, VFBGA, 6.6X6.6, 205, 4100997111
Ar3(7)(0)=SON, VFBGA, 6.5X6.5, 185, 4100997111
Ar3(8)(0)=SON, TFBGA, 6.5X6.5, 64, 4100997111
Ar3(9)(0)=SON, VFBGA, 6.5X6.5, , 4100997111
Ar3(10)(0)=SON, BGA, 6.5X6.5, 64, 4100997111
Ar3(11)(0)=SON, BGA, 6.5X6.5, 72, 4100997111
Ar3(12)(0)=SON, BGA, 6.5X6.5, 112, 4100997111
Ar3(13)(0)=SON, VFBGA, 6.5X6.5, 185, 4100997111
Ar3(14)(0)=SON, TFBGA, 6.5X6.5, 64, 4100997111
Ar3(15)(0)=SON, VFBGA, 6.5X6.5, , 4100997111
Ar3(16)(0)=SON, BGA, 6.5X6.5, 64, 4100997111
Ar3(17)(0)=SON, BGA, 6.5X6.5, 72, 4100997111
Ar3(18)(0)=SON, BGA, 6.5X6.5, 112, 4100997111

M.T.K., VFBGA, 10.6X11, 475
Arr(1)(0)=UM9, M.T.K.
Ar2(1)(0)=UM9, VFBGA, 10.6X11, 475, 4101668111

M.T.K., VFBGA, 6.2X6.2, 196
Arr(1)(0)=UM9, M.T.K.
Ar2(1)(0)=UM9, VFBGA, 6.2X6.2, 196, 4101439111
Ar3(1)(0)=UM9, aQFN, 6.2X6.2, 62, 4101439111

KING YUAN, aQFN, 6.2X6.2, 62
Arr(1)(0)=KYE, KING YUAN
Arr(2)(0)=KYE, KING YUAN
Ar2(1)(0)=KYE, aQFN, 6.2X6.2, 62, 4101439111
Ar3(1)(0)=UM9, VFBGA, 6.2X6.2, 196, 4101439111
Ar2(2)(0)=KYE, aQFN, 6.2X6.2, 62, 4101439111
Ar3(2)(0)=UM9, VFBGA, 6.2X6.2, 196, 4101439111
Ar3(3)(0)=UM9, VFBGA, 6.2X6.2, 196, 4101439111

M.T.K., VFBGA, 6.2X5.4, 175
Arr(1)(0)=UM9, M.T.K.
Ar2(1)(0)=UM9, VFBGA, 6.2X5.4, 175, 4101912111

CYPRESS, QFN, 3X3, 0
Arr(1)(0)=CPS, CYPRESS
Arr(2)(0)=CPS, CYPRESS

CYPRESS, QFN, 3X3, 0
Arr(1)(0)=CPS, CYPRESS
Arr(2)(0)=CPS, CYPRESS

TOP

c_c_lai

帖子
2035 
主題
24 
精華
0 
積分
2031 
點名
0  
作業系統
Win7 
軟體版本
Office2010 
閱讀權限
100 
性別
男 
註冊時間
2012-3-22 
最後登錄
2024-2-1 
45#
發表於 2016-12-1 11:39 | 只看該作者
回復 42# starbox520

ATI, BGA, 37.5X37.5, 0
Arr(1)(0)=ATI, ATI

ATMEL, TQFP, 14X14, 64
Arr(1)(0)=ACS, ATMEL
Arr(2)(0)=ATM, ATMEL
Arr(3)(0)=ES2, ATMEL
Arr(4)(0)=EUR, ATMEL
Arr(5)(0)=MRS, ATMEL
Arr(6)(0)=NPM, ATMEL
Ar2(1)(0)=ATM, TQFP, 14X14, 64, 4101149111
Ar2(2)(0)=ATM, TQFP, 14X14, 64, 4101149111
Ar2(3)(0)=ATM, TQFP, 14X14, 64, 4101132111
Ar3(1)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(2)(0)=ATM, TQFP, 14X14, 64, 4101149111
Ar3(3)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(4)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(5)(0)=ATM, TQFP, 14X14, 64, 4101149111
Ar3(6)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(7)(0)=ATM, LQFP, 14X14, 64, 4101132111
Ar3(8)(0)=ATM, LQFP, 14X14, 128, 4101132111
Ar3(9)(0)=ATM, LQFP, 14X14, 80, 4101132111
Ar3(10)(0)=ATM, LQFP, 14X14, 64, 4101132111
Ar3(11)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(12)(0)=ATM, TQFP, 14X14, 64, 4101149111
Ar3(13)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(14)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(15)(0)=ATM, TQFP, 14X14, 64, 4101149111
Ar3(16)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(17)(0)=ATM, LQFP, 14X14, 64, 4101132111
Ar3(18)(0)=ATM, LQFP, 14X14, 128, 4101132111
Ar3(19)(0)=ATM, LQFP, 14X14, 80, 4101132111
Ar3(20)(0)=ATM, LQFP, 14X14, 64, 4101132111
Ar3(21)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(22)(0)=ATM, TQFP, 14X14, 64, 4101149111
Ar3(23)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(24)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(25)(0)=ATM, TQFP, 14X14, 64, 4101149111
Ar3(26)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(27)(0)=ATM, LQFP, 14X14, 64, 4101132111
Ar3(28)(0)=ATM, LQFP, 14X14, 128, 4101132111
Ar3(29)(0)=ATM, LQFP, 14X14, 80, 4101132111
Ar3(30)(0)=ATM, LQFP, 14X14, 64, 4101132111
Ar2(4)(0)=MRS, TQFP, 14X14, 64, 4101149111
Ar3(31)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(32)(0)=ATM, TQFP, 14X14, 64, 4101149111
Ar3(33)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(34)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(35)(0)=ATM, TQFP, 14X14, 64, 4101149111
Ar3(36)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(37)(0)=ATM, LQFP, 14X14, 64, 4101132111
Ar3(38)(0)=ATM, LQFP, 14X14, 128, 4101132111
Ar3(39)(0)=ATM, LQFP, 14X14, 80, 4101132111
Ar3(40)(0)=ATM, LQFP, 14X14, 64, 4101132111
Ar3(41)(0)=ATM, TQFP, 14X14, 64, 4101149111
Ar3(42)(0)=ATM, TQFP, 14X14, 64, 4101149111
Ar3(43)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(44)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(45)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(46)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(47)(0)=ATM, TQFP, 14X14, 64, 4101149111
Ar3(48)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(49)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(50)(0)=ATM, TQFP, 14X14, 64, 4101149111
Ar3(51)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(52)(0)=ATM, LQFP, 14X14, 64, 4101132111
Ar3(53)(0)=ATM, LQFP, 14X14, 128, 4101132111
Ar3(54)(0)=ATM, LQFP, 14X14, 80, 4101132111
Ar3(55)(0)=ATM, LQFP, 14X14, 64, 4101132111
Ar3(56)(0)=ATM, TQFP, 14X14, 64, 4101149111
Ar3(57)(0)=ATM, TQFP, 14X14, 64, 4101149111
Ar3(58)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(59)(0)=ATM, TQFP, 14X14, 100, 4101149111
Ar3(60)(0)=ATM, TQFP, 14X14, 100, 4101149111

KING YUAN, VFBGA, 12.6X12.6, 641
Arr(1)(0)=KYE, KING YUAN
Arr(2)(0)=KYE, KING YUAN
Ar2(1)(0)=KYE, VFBGA, 12.6X12.6, 641, 4101073111
Ar3(1)(0)=UM9, VFBGA, 12.6X12.6, 677, 4101073111
Ar3(2)(0)=UM9, BGA, 12.6X12.6, 669, 4101073111
Ar2(2)(0)=KYE, VFBGA, 12.6X12.6, 641, 4101073111
Ar3(3)(0)=UM9, VFBGA, 12.6X12.6, 677, 4101073111
Ar3(4)(0)=UM9, BGA, 12.6X12.6, 669, 4101073111
Ar3(5)(0)=UM9, VFBGA, 12.6X12.6, 677, 4101073111
Ar3(6)(0)=UM9, BGA, 12.6X12.6, 669, 4101073111

ATI, BGA, 23X23, 0
Arr(1)(0)=ATI, ATI

MEDTRONIC, LFBGA, 10.5X14, 191
Arr(1)(0)=MTN, MEDTRONIC

ATMEL, LFBGA, 15X15, 217
Arr(1)(0)=ACS, ATMEL
Arr(2)(0)=ATM, ATMEL
Arr(3)(0)=ES2, ATMEL
Arr(4)(0)=EUR, ATMEL
Arr(5)(0)=MRS, ATMEL
Arr(6)(0)=NPM, ATMEL

CYPRESS, UFBGA, 7X5, 111
Arr(1)(0)=CPS, CYPRESS
Arr(2)(0)=CPS, CYPRESS
Ar2(1)(0)=CPS, UFBGA, 7X5, 111, 4102340111
Ar3(1)(0)=PRD, UFBGA, 7X5, 111, 4102340111
Ar2(2)(0)=CPS, UFBGA, 7X5, 111, 4102340111
Ar3(2)(0)=PRD, UFBGA, 7X5, 111, 4102340111
Ar3(3)(0)=PRD, UFBGA, 7X5, 111, 4102340111

M.T.K., VFBGA, 13X13.4, 0
Arr(1)(0)=UM9, M.T.K.

SILERGY, LQFP, 10X10, 64

ATI, BGA, 29X29, 962
Arr(1)(0)=ATI, ATI

M.T.K., VFBGA, 13X13.4, 873
Arr(1)(0)=UM9, M.T.K.
Ar2(1)(0)=UM9, VFBGA, 13X13.4, 873, 4102319111

M.T.K., VFBGA, 13X13.4, 0
Arr(1)(0)=UM9, M.T.K.

M.T.K., VFBGA, 13X13.4, 873
Arr(1)(0)=UM9, M.T.K.
Ar2(1)(0)=UM9, VFBGA, 13X13.4, 873, 4102319111

KING YUAN, VFBGA, 12.6X12.6, 641
Arr(1)(0)=KYE, KING YUAN
Arr(2)(0)=KYE, KING YUAN
Ar2(1)(0)=KYE, VFBGA, 12.6X12.6, 641, 4101073111
Ar3(1)(0)=UM9, VFBGA, 12.6X12.6, 677, 4101073111
Ar3(2)(0)=UM9, BGA, 12.6X12.6, 669, 4101073111
Ar2(2)(0)=KYE, VFBGA, 12.6X12.6, 641, 4101073111
Ar3(3)(0)=UM9, VFBGA, 12.6X12.6, 677, 4101073111
Ar3(4)(0)=UM9, BGA, 12.6X12.6, 669, 4101073111
Ar3(5)(0)=UM9, VFBGA, 12.6X12.6, 677, 4101073111
Ar3(6)(0)=UM9, BGA, 12.6X12.6, 669, 4101073111

KING YUAN, VFBGA, 12.6X12.6, 641
Arr(1)(0)=KYE, KING YUAN
Arr(2)(0)=KYE, KING YUAN
Ar2(1)(0)=KYE, VFBGA, 12.6X12.6, 641, 4101073111
Ar3(1)(0)=UM9, VFBGA, 12.6X12.6, 677, 4101073111
Ar3(2)(0)=UM9, BGA, 12.6X12.6, 669, 4101073111
Ar2(2)(0)=KYE, VFBGA, 12.6X12.6, 641, 4101073111
Ar3(3)(0)=UM9, VFBGA, 12.6X12.6, 677, 4101073111
Ar3(4)(0)=UM9, BGA, 12.6X12.6, 669, 4101073111
Ar3(5)(0)=UM9, VFBGA, 12.6X12.6, 677, 4101073111
Ar3(6)(0)=UM9, BGA, 12.6X12.6, 669, 4101073111

KING YUAN, VFBGA, 12.6X12.6, 641
Arr(1)(0)=KYE, KING YUAN
Arr(2)(0)=KYE, KING YUAN
Ar2(1)(0)=KYE, VFBGA, 12.6X12.6, 641, 4101073111
Ar3(1)(0)=UM9, VFBGA, 12.6X12.6, 677, 4101073111
Ar3(2)(0)=UM9, BGA, 12.6X12.6, 669, 4101073111
Ar2(2)(0)=KYE, VFBGA, 12.6X12.6, 641, 4101073111
Ar3(3)(0)=UM9, VFBGA, 12.6X12.6, 677, 4101073111
Ar3(4)(0)=UM9, BGA, 12.6X12.6, 669, 4101073111
Ar3(5)(0)=UM9, VFBGA, 12.6X12.6, 677, 4101073111
Ar3(6)(0)=UM9, BGA, 12.6X12.6, 669, 4101073111

CYPRESS, LBGA, 6X10, 48
Arr(1)(0)=CPS, CYPRESS
Arr(2)(0)=CPS, CYPRESS
Ar2(1)(0)=CPS, LBGA, 6X10, 48, 4101906111
Ar2(2)(0)=CPS, LBGA, 6X10, 48, 4101906111

STM, LFBGA, 15X15, 289
Arr(1)(0)=THM, STM
Arr(2)(0)=THM, STM
Arr(3)(0)=THM, STM
Arr(4)(0)=THM, STM

M.T.K., VFBGA, 10.6X11, 475
Arr(1)(0)=UM9, M.T.K.
Ar2(1)(0)=UM9, VFBGA, 10.6X11, 475, 4101668111

M.T.K., TFBGA, 10.2X11, 0
Arr(1)(0)=UM9, M.T.K.

M.T.K., VFBGA, 13X13.4, 873
Arr(1)(0)=UM9, M.T.K.
Ar2(1)(0)=UM9, VFBGA, 13X13.4, 873, 4102319111

CYPRESS, LFBGA, 10X10, 121
Arr(1)(0)=CPS, CYPRESS
Arr(2)(0)=CPS, CYPRESS
Ar2(1)(0)=CPS, LFBGA, 10X10, 121, 4102601111
Ar2(2)(0)=CPS, LFBGA, 10X10, 121, 4102601111

TOP

starbox520

帖子
192 
主題
15 
精華
0 
積分
194 
點名
0  
作業系統
windows 
軟體版本
office2010 
閱讀權限
20 
性別
女 
註冊時間
2016-9-22 
最後登錄
2020-8-28 

論壇榮譽勳章論壇贊助勳章
46#
發表於 2016-12-1 15:17 | 只看該作者
回復 45# c_c_lai

ATMEL, TQFP, 14X14, 100
此筆就有找到2個
ATMEL        TQFP        14X14        100        10495        21307        184        31986
ATMEL        TQFP        14X14        64        34295        22306        1574        58175

  C大是不是"材料"在找"工作表2"
  沒把簡碼再轉回來"全碼"??

TOP

c_c_lai

帖子
2035 
主題
24 
精華
0 
積分
2031 
點名
0  
作業系統
Win7 
軟體版本
Office2010 
閱讀權限
100 
性別
男 
註冊時間
2012-3-22 
最後登錄
2024-2-1 
47#
發表於 2016-12-1 16:06 | 只看該作者
回復 46# starbox520
是沒轉回 (CODE -> CUST_GROUP)，眼花撩亂地弄得頭暈了。

TOP

c_c_lai

帖子
2035 
主題
24 
精華
0 
積分
2031 
點名
0  
作業系統
Win7 
軟體版本
Office2010 
閱讀權限
100 
性別
男 
註冊時間
2012-3-22 
最後登錄
2024-2-1 
48#
發表於 2016-12-1 18:59 | 只看該作者
回復 46# starbox520
請核對一下附件內容是否正確。
1.rar (2.06 KB)

TOP

starbox520

帖子
192 
主題
15 
精華
0 
積分
194 
點名
0  
作業系統
windows 
軟體版本
office2010 
閱讀權限
20 
性別
女 
註冊時間
2016-9-22 
最後登錄
2020-8-28 

論壇榮譽勳章論壇贊助勳章
49#
發表於 2016-12-1 19:04 | 只看該作者
回復 47# c_c_lai


    對壓
    你注意看，只有材料是簡碼
    TR排機&產出 找材料   需要找簡碼
    材料找工作表2又要轉全碼!!!
    附檔我研究一下下唷><

TOP

starbox520

帖子
192 
主題
15 
精華
0 
積分
194 
點名
0  
作業系統
windows 
軟體版本
office2010 
閱讀權限
20 
性別
女 
註冊時間
2016-9-22 
最後登錄
2020-8-28 

論壇榮譽勳章論壇贊助勳章
50#
發表於 2016-12-1 21:52 | 只看該作者
回復 48# c_c_lai


    抱歉我還是用附檔上面提供的欄位名稱敘述好了
    我好像講給自己聽得懂的哈哈
    "TR排機&產出"  去找  "材料"   要透過"Cus簡碼"的    CODE   

     "材料"     去找"工作表2"    要透過"Cus簡碼"的    CUST_GROUP
   
   
    您的附檔，應該是正確的答案

TOP

        靜思自在 : 犯錯出懺悔心，才能清淨無煩惱。
1 ...3456789101112... 19
返回列表 上一主題