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

³]©w®æ¦¡¤Æ±ø¥ó ¶i¶¥ª©

³]©w®æ¦¡¤Æ±ø¥ó ¶i¶¥ª©

1.·íB12=2 ..B2©MB3¥²¶·Åܦâ..¦¹¥~B12¤£¤@©w·|¬O2.¦pªG¬O4¬Û¹ïªºB2.B3.B4.B5³o¥|­ÓÀx¦s®æ¤]­nÅܦâ
2.·íB14.C14.D14¤À§Oµ¥©ó5.8.9.¦¹®ÉF1.I1.J1¥²¶·Åܦâ.¦]¬°¥L­ÌªºÀx¦s®æ¬°5.8.9

§¹¦¨¹Ï¦p¤U:
http://naturefruit.myweb.hinet.net/x3.xls

¬Ý¹Ï¤ñ¸û²LÅã©öÀ´..¨¯­W¤j®a¤F..!

¥»©«³Ì«á¥Ñ gong ©ó 2010-6-18 15:06 ½s¿è

1.¿ïB1: P1>®æ¦¡>³]©w®æ¦¡¤Æ±ø¥ó>¤½¦¡¬°>
=COUNTIF($14: $14,B$1)
>¹Ï¼Ë>ÂŦâ

2.¿ïB2: P10>®æ¦¡>³]©w®æ¦¡¤Æ±ø¥ó>¤½¦¡¬°
=(ROW()-2)<B$12
>¹Ï¼Ë>ºñ¦â

¦p­nª½±µ¤Þ¥Î¤½¦¡½Ðª`·N":"«á­±¦³"ªÅ¥Õ"
«Y¦]µLªÅ¥Õ°Ï®æ·|¦³,½Ð¦Û¦æ§R°£"ªÅ¥Õ"

Book1.rar (7.18 KB)

ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

gong ¤j¤jªº¸Ñµª§¹¥þ¸ò§Ú·Q­nªº¤@¼Ë!

TOP

1.¿ïB1: P1>®æ¦¡>³]©w®æ¦¡¤Æ±ø¥ó>¤½¦¡¬°>
=COUNTIF($14: $14,B$1)
>¹Ï¼Ë>ÂŦâ

2.¿ïB2: P10>®æ¦¡>³]©w®æ ...
gong µoªí©ó 2010-6-18 15:01


gong ª©¥D
½Ð®¤¤p§Ì¦h¨¥
¦^ÂÐ¥DÃD®É¤Ä¿ï"¸T¥Îªí±¡"§Y¥i¸Ñ¨M

=COUNTIF($14:$14,B$1)
¾÷¾¹¤H¤T¤j©w«ß-«OÅ@¤HÃþ¡BªA±q©R¥O¡B«OÅ@¦Û¤v
§Úªº¤T¤j©w«ß-¥Í©R¡B¥Í¦s¡B¥Í¬¡

TOP

ÁÂÁ´£¿ô,§Ú¤£ª¾¹D¦³³o¥\¯à
ÁÙ¬O§A¤ñ¸û¦³¬ã¨s
¦V§A¾Ç²ß¤F
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

        ÀR«ä¦Û¦b : ª¾ÃÑ­n¥Î¤ßÅé·|¡A¤~¯àÅܦ¨¦Û¤vªº´¼¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD