| 楼主 piny |
第一次發表，不曉得有無符合原創? 儲存格若含有「褲」，則為下裝，否則則為上裝。 32 =IF(COUNTIF(A2,"*裤*"),"下装","上装") 33 =TEXT(COUNTIF(A2,"*裤*"),"下装;;上装") 34 =IF(COUNT(FIND("裤",A2)),"下装","上装") 34 =IF(ISERR(FIND("裤",A2)),"上装","下装") 34 =MID("上装下装",3^COUNTIF(A2,"*裤*"),2) 35 =TEXT(COUNT(FIND("裤",A2)),"下装;;上装") 35 =TEXT(-ISERR(FIND("裤",A2)),"下装;上装") 36 =MID("上装下装",3^COUNT(FIND("裤",A2)),2) 36 =MID("下装上装",3^ISERR(FIND("裤",A2)),2) 37 =IF(ISNUMBER(FIND("裤",A2)),"下装","上装") 37 =IF(SUBSTITUTE(A2,"裤",)=A2,"上装","下装") 38 =TEXT(-ISNUMBER(FIND("裤",A2)),"上装;下装") 38 =TEXT(-ISNA(MATCH("*裤*",A2,)),"下装;上装") 39 =INDEX({"上装","下装"},COUNTIF(A2,"*裤*")+1) 39 =IF(FIND("裤",A2&"裤")>LEN(A2),"上装","下装") 39 =MID("上装下装",3^ISNUMBER(FIND("裤",A2)),2) 40 =LOOKUP(,-FIND({"","裤"},A2),{"上装","下装"}) 41 =INDEX({"上装","下装"},COUNT(FIND("裤",A2))+1) 41 =MID("上下",COUNT(,MATCH("*裤*",A2,)),1)&"装" 41 =REPLACE("下装上装",3^COUNT(FIND("裤",A2)),2,) 41 =TEXT(-(SUBSTITUTE(A2,"裤",)<>A2),"上装;下装") 41 =INDEX({"下装","上装"},ISERR(FIND("裤",A2))+1) 42 =MID("上装下装",3^(SUBSTITUTE(A2,"裤",)<>A2),2) 43 =TEXT(-(LEN(A2)>=FIND("裤",A2&"裤")),"上装;下装") 44 =INDEX({"上装","下装"},ISNUMBER(FIND("裤",A2))+1) 46 =LOOKUP(COUNT(FIND("裤",A2)),{0,1},{"上装","下装"}) 46 =VLOOKUP(COUNTIF(A2,"*裤*"),{1,"下装";0,"上装"},2,) 46 =HLOOKUP(COUNTIF(A2,"*裤*"),{1,0;"下装","上装"},2,) 47 =IF(LEN(SUBSTITUTE(A2,"裤",))<LEN(A2),"下装","上装") 48 =IF(SUM(N(MID(A2,COLUMN(1:1),1)="裤")),"下装","上装") 48 =TEXT(LEN(A2)-LEN(SUBSTITUTE(A2,"裤",)),"下装;;上装") 51 =IF(COUNT(1/(MID(A2,COLUMN(1:1),1)="裤")),"下装","上装")  piny-上下裝問題.zip |
| 2楼 laowuwyx |
piny也到这里来逛了索，顶一个！ |
| 3楼 piny |
哈 剛報到 ^^ |
| 4楼 piny |
To wjc2090742老師 謝謝加分鼓勵，題目就在第一行呀 「儲存格若含有「褲」，則為下裝，否則則為上裝。 」 |
| 5楼 wise |
总算加精了 |
| 6楼 gouweicao78 |
piny兄思路钻研比较深啊，呵呵。不过由于繁体、简体表述存在一定差异，还是会有点儿不习惯。 |
| 7楼 piny |
哈，謝謝版主肯定，先前跨足簡体論壇，也同步在繁體論壇中解惑，就常常不知所云，聽者一頭霧水 較常見差異有 欄列 與 列行 陣列 與 數組 民國紀年的用法 indirect(!R1C1)，R前要加! TEXT對於星期幾的表述方式 LOOKUP等查找係以筆劃思考 ... 也還在慢慢學習，也很高興愈來愈多簡体字認識了我 ^^ |
| 8楼 gouweicao78 |
在繁体中，LOOKUP以笔画多少升序吗？简体中应该是以拼音升序的。 |
| 9楼 wjc2090742 |
 恭喜piny兄，初出手便是精华，还希望经常在ET活跃，带来更多精彩 。补一个replace的，不是很完善，也不短，重在参与同乐。=REPLACE("下上装",COUNTIF(A2,"*裤*")+1,1,) |
| 10楼 wise |
 再次学习 |