ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] §ä¥X­«½Æ¸ê®Æ,¨Ã§R°£ªº¨ç¼Æ?

[µo°Ý] §ä¥X­«½Æ¸ê®Æ,¨Ã§R°£ªº¨ç¼Æ?

¦b½d³òÀx¦s®æ¤º§ä¥X­«½Æ¸ê®Æ¨Ã¥B§R°£¡A½Ð°Ý­n«ç»ò³]©w¡H
¦p¡GAAA¦³¢´­Ó§R°£¢³­Ó¡A¥u¯d¢°­Ó
¢²¢ù

http://blog.xuite.net/hcm19522/twblog/225435151

TOP

AÄæ¬O¸ê®Æ
B1 =COUNTIF(A$1:A1,A1)
¤U©Ô½Æ»s¤½¦¡

¿z¿ïBÄæ>1¡A¿ï¨ú - §R°£
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¦³´¼¼z¤~¯à¤À¿ëµ½´c¨¸¥¿¡F¦³Á¾µê¤~¯à«Ø¥ß¬üº¡¤H¥Í¡C
ªð¦^¦Cªí ¤W¤@¥DÃD