excel2010????????

admin

????EXCEL?????????????

?EXCEL??????????????

??A? � ?? � ???? � ?? =countif(a$1:a1,a1)>1 � ???????

?????????

????????B? ???=countif(a$1:a1,a1)>1 ???????????? ???? ??? TRUE

????excel??????????????

?excel??????????????

??excel2010???

~???????excel?????????????

~?????????????????????????????? ~?????????????????

?????????????????

1???????????????

2???�????�->�?????????�->�???�

3????????????????

4???�??�??????????�???�???

?????B????A?????

?????A?????????????B1???fx??????? =IF(COUNTIF(A:A,A1)>1,"??",""? ?????

?????

??????B1??????????????????????????????�???�???

???????????????????????

?????Excel?????

?COUNTIF????Excel?????

??2???

???????????

??????if?????

??1?=COUNTIF(A:A,"?") ??A?????"?"??? =COUNTIF(A2:Q2,"?") ?????????"?"???

??2?=COUNTIF(A:A,A2) ?A??????????????????1???????A2??????????

??3?=IF(COUNTIF(A:A,A1)>1,"??","???")

??4???????????????????????A???????????????????=COUNTIF(A:A,A2)>1,???????????????????????


?excel2010????????????????
?????http://www.850500.com/news/28235.html
?????,??!