返回列表 上一主題 發帖

[發問] 多條件篩選&ListBox

本帖最後由 c_c_lai 於 2016-11-30 07:49 編輯

回復 25# starbox520
看到妳最後語帶玄機地描述:

第3種: 4 個條件都吻合, 此筆資料就有一筆要列出。
第4種: 3個皆吻合,如果資料與第3種長的一樣,就判定為第3種
第5種: 2個皆吻合,如果資料與第4種長的一樣,就判定為第4種

好!
那只待妳就把 第1種 與 第2種 的判斷條件說明一下了。
P.S.  我發現在 #25 妳才講到了重點,所謂的 "好酒飲暗底"!

TOP

回復 25# starbox520
事後想想,妳後來所說的:
第 3 ~ 5 種  ( 與 工作表 "材料" ) 無關,
亦即不用 對應到 工作表 "CUS簡碼",以及
工作表 "材料" 了囉?
只有 第 1 ~ 2 種 才需要 對應到 工作表 "CUS簡碼"?  
接著又再透過 ("BA"、"AZ") 對應到 工作表 "材料"、
然後再對應到  "工作表2" ?

P.S.  義大利有部影片,叫做 "媽媽咪 (Mama Mia)!"

TOP

本帖最後由 c_c_lai 於 2016-11-30 15:38 編輯

回復 29# starbox520
3 ~ 5 比對欄位如下:
A0L.png
那 1~ 2 又需比對那些欄位,才算是完整的公式呢?
看你的範例,有的是 P、Q,又有的是 P、Q、R 之類的。

Mama Mia 是形容頭昏腦脹了!

TOP

回復 32# starbox520
也就是說 #1 是不正確的?

TOP

回復 34# starbox520
那結論是:
#23 的解說才是正確的?
此 "比對" 是完全適用於 第 1 種、與    第 2 種 嗎?
此邏輯是不能模糊不清的。

TOP

回復 36# starbox520
每次點選均要執行 1 ~ 5 的比對過程嗎?

TOP

回復 38# starbox520
"BA"、以及 "AZ" 亦要比對 "P"、"Q"、"R" 三個欄位值嗎?
而且 三個欄位 必須一致?

TOP

本帖最後由 c_c_lai 於 2016-12-1 08:44 編輯

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

TOP

回復 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

回復 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

        靜思自在 : 人事的艱難與琢磨,就是一種考驗。
返回列表 上一主題