答案出B…若找到 C, 答案出C
更新1:
多謝!!!!!!! 你們真的是勁人,但如果我只是要找A或B或C或D或E,而找到其他嘢例如#N/A就當無嘢, &不顯示,有無可能 如下只C ABCDEFG 1#N/A#N/A#N/A#N/AC#N/A#N/A 2 3
EXCEL可否有程式自動找 儲存格內是否有 A 或 B或 C
2011-08-07 7:12 am
ABCDEFG12B無嘢無嘢E2= 想自動找 A2, B2, C2儲存格內是否有 A 或 B或 C 34無嘢C無嘢J 是話,可否有程式自動找 A4 至 C4儲存格內是否有 A 或 B或 C 5若找到 A, 答案出A….若找到 B,
答案出B…若找到 C, 答案出C
答案出B…若找到 C, 答案出C
回答 (2)
2011-08-07 7:06 pm
✔ 最佳答案
因你嘅目標只係 ABC 三個, 重複或組合出現亦有可能, 我就會用呢個方法:E2=IF((COUNTIF(A2:C2,"A")>0+COUNTIF(A2:C2,"B")>0+COUNTIF(A2:C2,"C")>0)>1,"Mix ","")&IF(COUNTIF(A2:C2,"A")>0,"A","")&IF(COUNTIF(A2:C2,"B")>0,"B","")&IF(COUNTIF(A2:C2,"C")>0,"C","")
2011-08-07 6:14 pm
在E2輸入
=IF(A1="","",A1)&IF(B1="","",B1)&IF(C1="","",C1)
就會得到你的結果.
=IF(A1="","",A1)&IF(B1="","",B1)&IF(C1="","",C1)
就會得到你的結果.
收錄日期: 2021-04-23 23:38:42
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20110806000051KK01278