Re: [算表] 尋找第2碼或第3碼字為特定文字

[windknife18 (windknife18)]

將Sheet2的B1公式改成以下的，這樣只會比對從前面開始一樣的

=IF(ISNA(LOOKUP(E9+307,IF(Sheet1!$A$1:$A$100="","",
SEARCH(Sheet1!$A$1:$A$100,A1)))),"NO",IF(LOOKUP(E9+307,
IF(Sheet1!$A$1:$A$100="","",SEARCH(Sheet1!$A$1:$A$100,A1)))=1,"OK","NO"))

輸入完記得按 Ctrl+Shift+Enter 結束


--
※ 發信站: 批踢踢實業坊(ptt.cc) 
◆ From: 61.229.78.219
推 toroma:哇 謝謝 真是太厲害了
→ windknife18:^^