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

²Î­pBÄæ¤H¼Æ

²Î­pBÄæ¤H¼Æ

¦U¦ì«e½ú§A­Ì¦n!     
         °ÝÃD¦pªþÀÉ»¡©ú
         ½Ðª¾¹Dªº«e½ú,¤£§[½ç±ÐÁÂÁ¦A¤T!!

Leo29.rar (7.94 KB)

¦^´_ 1# myleoyes


    0.0 ¤p§Ì¤£¤~ ¶È¯à°µ¥X¥H¤UÀÉ®×.. XDD
Leo29.rar (7.7 KB)

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

¦^´_ 1# myleoyes

=SUMPRODUCT(1/COUNTIF($B$3:$B$30,$B$3:$B$30))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 3# Hsieh
mark15jill «e½ú!ÁÂÁÂ!!³o¼Ë¥²¶·¦h¥[¤@¸É§UÄæ
                   «D¤p§Ì©Ò­nÁÂÁ¦A¤T!!
°¸¹³«e½ú!ÁÂÁÂ!!¤p§Ì©¿²¤»¡©ú¦³®Ä½d³ò$B$3:$B$300
½d¨ÒBÄæ¨Ï¥Î30¦C®É  B1=SUMPRODUCT(1/COUNTIF($B$3:$B$30,$B$3:$B$30))¥¿½T
¦ý¬OBÄæ¨Ï¥Î½d³ò¶W¹L30¦C®É,«h¥²¶·­×§ï¤½¦¡¤~¥i¥H
¦]¬°BÄ檺¨Ï¥Î¦C¬O°ÊºAªº¦³®É¦h,¦³®É¤Ö¤£©T©w
¤½¦¡¦]¸Ó¬O¦b«ü©w300¦C¤§¤º¤£ºÞ¨Ï¥Î¦C¦h¹è³£¯à²Î­p¤H¼Æ
½Ð¦A³Â·Ð­×§ï¤@¤U¨¯­WÅo!ÁÂÁ¦A¤T!!

TOP

¦^´_ 4# myleoyes


    http://forum.twbts.com/thread-1405-1-1.html
¨Ï¥Î°ÊºA½d³ò©w¸q¦WºÙ
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 5# Hsieh
°¸¹³«e½ú!ÁÂÁÂ!!³o¹ï¤p§Ì¨Ó»¡¬O¦³ÂI§xÃø...
        ¤p§ÌºCºC´¢¼¯¬Ý¬ÝÁÂÁ¦A¤T!!

TOP

¦^´_ 6# myleoyes

©w¸q¦WºÙx¤½¦¡
    =INDIRECT("Sheet1!B3:B"&LOOKUP(2,1/(Sheet1!$B$2:$B$301<>""),ROW(Sheet1!$B$2:$B$301)))
B1¤½¦¡
=SUMPRODUCT(1/COUNTIF(x,x))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 7# Hsieh
°¸¹³«e½ú!«D±`ÁÂÁÂ!ÁÂÁ¦A¤T!!

TOP

  ¦^´_ 4# myleoyes
... ¤½¦¡¦]¸Ó¬O¦b«ü©w300¦C¤§¤º¤£ºÞ¨Ï¥Î¦C¦h¹è³£¯à²Î­p¤H¼Æ............


¤½¦¡«ü©w¦b300¦C¤§¤º, ¤£ºÞ¨Ï¥Î¦C¦h¹è, ³£¯à²Î­p¤H¼Æ :

=SUMPRODUCT(($B$3:$B$300<>"")/COUNTIF($B$3:$B$300,$B$3:$B$300&""))

TOP

¥»©«³Ì«á¥Ñ zz5151353 ©ó 2012-11-19 13:46 ½s¿è
¤½¦¡«ü©w¦b300¦C¤§¤º, ¤£ºÞ¨Ï¥Î¦C¦h¹è, ³£¯à²Î­p¤H¼Æ :

=SUMPRODUCT(($B$3B$300"")/COUNTIF($B$3 ...
JBY µoªí©ó 2012-11-18 23:01


Áo©ú,¥i±¤§Ú¨Ó¿ð¤F.
=SUMPRODUCT(1/COUNTIF($B$3:$B$300,$B$3:$B$300&""))-1
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡µLªk¾B¾×¡j©È®É¶¡®ø³u¡Aªá¤F³\¦h¤ß¦å¡A·QºÉ¦U¦¡¤èªk­n¾B¾×®É¶¡¡Aµ²ªG¬O¡G®ö¶O¤F§ó¦h®É¶¡¡A¥B¤@µL©Ò¦¨¡I
ªð¦^¦Cªí ¤W¤@¥DÃD