而家有一欄資料由A1至A100(eg. ID No.)
想CHECK果批ID有冇重覆輸入
想做到o係B1至B100果欄可以顯示
有重覆=1(同時儲存格變黃色) 冇重覆=0
請問可以點做??
Excel公式(核對重覆資料)
2008-07-10 8:50 am
回答 (2)
2008-07-10 4:34 pm
✔ 最佳答案
有重覆=1 冇重覆=0B1用以下formula便可, 再向下覆製到B100
=IF(COUNTIF(A:A,A1)>1,1,0)
(同時儲存格變黃色)
用conditional formatting
Format only cells that contains
Equals to 1 : 1
再按選黃色做格仔既format
參考: excel experience
2008-07-11 4:17 am
Can follow the steps listed in below weblink
http://office.microsoft.com/en-us/excel/HA011366161033.aspx?pid=CL100570551033
http://office.microsoft.com/en-us/excel/HA011366161033.aspx?pid=CL100570551033
收錄日期: 2021-04-16 12:12:51
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20080710000051KK00145