- ©«¤l
- 57
- ¥DÃD
- 21
- ºëµØ
- 0
- ¿n¤À
- 83
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2015-9-18
- ³Ì«áµn¿ý
- 2022-9-13
|
¥»©«³Ì«á¥Ñ mark761222 ©ó 2015-11-10 00:30 ½s¿è
A4- =IF(COUNTIF(A1:A3,1)>=1,"",1)&IF(COUNTIF(A1:A3,2)>=1,"",2)&IF(COUNTIF(A1:A3,3)>=1,"",3)&IF(COUNTIF(A1:A3,4)>=1,"",4)&IF(COUNTIF(A1:A3,5)>=1,"",5)
½Æ»s¥N½X IF(COUNTIF(A1:A3,1)>=1,"",1)
COUNIF ¦¬¸ß½d³ò1¦³¨S¦³¥X²{¡A¦pªG¥X²{1¦¸¥H¤W¤£Åã¥Ü¡A¨S¥X²{Åã¥Ü1, ¨ä¥L¥þ³¡¥Î&¦ê±µ°_¨Ó |
|