Excel 一問~ 請excel高人指點

2006-12-19 1:42 am
個case係咁既~

假設我有column A 同 column B (每個column有10個cells)
我想將A1同 (B1 - B10) 每一個cell compare
如果是但一個B column 既cell, 同A1相同 (A同B都唔係 number, 係text)
咁就return一個true value

我試過用exact, 或者or exact
做唔到我要既效果
or exact係唔係都會return false
可能我唔識寫...

我既寫法係咁既:
=OR(EXACT(A1,B1:B10))
By the way.. 呢個係office小幫手既寫法

出現既值.. 點都係false 喎...
而我自己都check 過.. B column 入面明明係有一個同A1相同..
我再直接用Exact黎check
=EXACT(A1, B3)
假設B3同A1一樣
咁就會出現True啦..
有冇高人可以幫幫我...

回答 (2)

2006-12-19 9:05 am
✔ 最佳答案
公式是: IF(COUNTIF($B$1:$B$10,A1)=0,FALSE,TRUE)
然後將公式複製或拖曳到下方的儲存格, 無需任何的修改
2006-12-19 1:46 am
Hi!

You can try using the If function.

Try to use this formula:
=If(A1=B1, TRUE!, FALSE!, true)

The above, "TRUE!" and "FALSE!" are the statement that will be returned, and true (the 3rd parameter) means that they have to be exactly the same in the comparison.

Try that and see if it works! Good luck!


收錄日期: 2021-04-29 18:37:30
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20061218000051KK02463

檢視 Wayback Machine 備份