EXCEL
2011-03-31 3:11 am
請問從網COPY的DATA放EXCEL是否不能用於COUNTIF/ VLOOKUP 等FUNCTION? 因試過唔WORK, 自己手打則用倒條FORMULA..THANKS
回答 (2)
2011-03-31 8:30 am
✔ 最佳答案
如果要 match, lookup 或 countif 一啲 numeric texts 嘅 targets, 唔將佢哋變返做數值, 可以反其道而行, 將你要揾出嘅值視為/化為文字:A1 = 100 數值
TEXT(A1,"general") = "100" 文字
CONCATENATE(A1) = "100" 文字
2011-03-31 10:24:32 補充：
你明唔明點 implement 落原有 formula 度?
=MATCH(A1, …
=MATCH(TEXT(A1, …
2011-03-31 5:07 am
或許DATA前後有些看不到的SPACE位, 可先用TRIM修正一下,
i.e. =TRIM(A1)
Please try
2011-03-31 07:30:46 補充：
try to convert your file to .rar file and upload to:
www.funp.net
it will more easier for people to solve your problem
i.e. =TRIM(A1)
Please try
2011-03-31 07:30:46 補充：
try to convert your file to .rar file and upload to:
www.funp.net
it will more easier for people to solve your problem
收錄日期: 2021-04-24 10:37:01
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20110330000051KK00900