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

[µo°Ý] ½Ð°Ý²Î­p¥X²{¦¸¼Æ­n¦p¦ó³]©w?

[µo°Ý] ½Ð°Ý²Î­p¥X²{¦¸¼Æ­n¦p¦ó³]©w?

¥»©«³Ì«á¥Ñ mrcv3 ©ó 2013-11-23 12:30 ½s¿è

¥X²{¦¸¼Æ.rar (1.91 KB)



³Â·Ð¦U¦ì¤j¤j¤£§[«ü±Ð¡AÁÂÁ¡C

¦^´_ 1# mrcv3

=COUNTIF(A2:A29,C2)

TOP

¦^´_ 2# aer


    ½Ð°Ý¤j¤j¡A»Ý¦b­þ³]±ø¥ó¡A¬O§_¦³¹Ï¨Ò¥i¬Ý¡A¦A³Â·Ð±z¤F¡AÁÂÁ¡C

TOP

¥»©«³Ì«á¥Ñ aer ©ó 2013-11-25 19:03 ½s¿è

¦^´_ 3# mrcv3
¥H±zªþ¥óÀɮ׬°¨Ò¡A
  1. D2=COUNTIF($A$2:$A$29,C2)   
½Æ»s¥N½X
¦V¤U½Æ»s

TOP

        ÀR«ä¦Û¦b : ¤f»¡¤@¥y¦n¸Ü¡A¦p¤f¥X½¬ªá¡F¤f»¡¤@¥yÃa¸Ü¦p¤f¦R¬r³D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD