H6 比對 F6 只要有9個條件其中之一，就會顯示1， 9個條件都沒有就空白
但是，數字用填的...太多了
=IF(OR(ISNUMBER(FIND({"47","45","44","54","57","55","74","75","77"},"*" &F6&"*")))+COUNT(F6),1,"")
我輸入457 會自動在B6 到B8 顯示9個條件
語法裡這段FIND({"47","45","44","54","57","55","74","75","77"} 能填入B6 到B8 格子
H6 也能達成一樣的結果嗎??
跪求大大幫忙修改...
※不可以用B6:D8 因為比對條件是單一的
