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

[µo°Ý]½Ð°Ý¡G²Å¦XAÄæ±ø¥ó¡A¥[Á`BÄ椧¤£­«½Æ­Èªº¶µ¥Ø­Ó¼Æ

[µo°Ý]½Ð°Ý¡G²Å¦XAÄæ±ø¥ó¡A¥[Á`BÄ椧¤£­«½Æ­Èªº¶µ¥Ø­Ó¼Æ

¦pªG§Ú·Q³]±ø¥ó"µ¥¯Å"¬°A¡A´N¥[Á`"«~¦W"¤¤ªº¤£­«½Æ¶µ¥Ø­Ó¼Æ¡A
(¥Ñ©ó«~¦W·|¤£Â_ÅÜ°Ê»P·s¼W¡A¬G¤£¯à¥H©T©w¬Y«~¦W¨Ó­pºâ)
½Ð°Ý¸Ó¨Ï¥Î¦óºØ¨ç¼Æ¹Bºâ¡H
§Æ±æ¯à¤£¨Ï¥ÎVBA»P°}¦C¤½¦¡¡AÁÂÁÂ!

¥»©«³Ì«á¥Ñ aer ©ó 2013-11-20 20:38 ½s¿è

¦^´_ 1# huangwed
  1. =SUMPRODUCT((C2:C15="A")*(1/COUNTIF(D2:D15,D2:D15)))
½Æ»s¥N½X

TOP

¦^´_ 2# aer

°Ú¡A§Ú¯u¬O½k¶î¡A§â³o­Ó·Q±o¤Ó½ÆÂø¤F!
¸U¤À·PÁÂ~·PÁ¸U¤À~

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2013-11-21 09:38 ½s¿è

¦^´_ 2# aer
©Ó1#µo°Ý¹Ï¥Üª¬ªp
­YC14Àx¦s®æÅܧó¬°A(D14Àx¦s®æ«~¦W¤´¬°¾ï¤l)¡A¥HSUMPRODUCT((C2:C15="A")*(1/COUNTIF(D2:D15,D2:D15)))­pºâ«á¨äµª®×¤£¬°4¡C
½Ð±Ðaer¤j¡A´N±z´£¨Ñªº²Õ¦X¤½¦¡¦Ó¨¥À³¦p¦ó­×§ï¡H
ÁÂÁ½ç±Ð¡I

TOP

¦^´_ 3# huangwed


½Ðª`·N! 2¼Ó¤½¦¡¨Ï¥Î¬O¦³­­¨îªº¡A¥u¯à¦b¦Uµ¥¯Å¶¡¶µ¥Ø¤£¯à­«½Æ¡C
¨Ò¦p ¥þ³¡§ï¬° ­»¿¼ ®É¡Aµª®×¬O0.375
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 1# huangwed


³o¬O°}¦C¤è¦¡ =COUNT(0/(MATCH("A"&D2:D15,C2:C15&D2:D15,)=ROW(1:14)))

«D°}¦C¤è¦¡µ¥¤¤¤È¦³ªÅ¦A·Q¬Ý¬Ý
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# aer


½Ð°Ý¯à§_À°§Ú¸ÑÄÀ¤@¤U³o¬q

(1/COUNTIF(D2:D15,D2:D15)))  ¬°¤°»ò³o²Ä¤G­Ó°}¦C¸Ì­±  ­n¥ý¥Î 1  °£ «á­±¨º±Æ

¥t¥~  COUNTIF ¨ç¼Æ ¬O¥ý¦C ½d³ò«á¨ú ¬O/§_­È  ¨âÃä³£©ñ¤@¼Ëªº ¥Lªº§PÂ_ÅÞ¿è¬O¤°»ò@@?

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2013-11-21 10:55 ½s¿è

¦^´_ 1# huangwed
¤£¨Ï¥ÎVBA¤]¤£¨Ï¥Î°}¦C¤½¦¡¨º´N±N¸ê®Æ¨Ì¾Úµ¥¯Å±Æ§Ç´N·|³æ¯Â«Ü¦h
=IF(COUNTIF(C:C,F1)=0,"",SUMPRODUCT(1/COUNTIF(OFFSET($C$1,MATCH(F1,$C:$C,0)-1,1,COUNTIF($C:$C,F1),),OFFSET($C$1,MATCH(F1,$C:$C,0)-1,1,COUNTIF($C:$C,F1),))))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# p212
­ì¤½¦¡¦p5#©Ò»¡ªº¡A¶µ¥Ø¤§¶¡¦³­«ÂСA­pºâ«á·|²£¥Í¤p¼ÆÂIªº°ÝÃD¡C
¥i¥H¦bEÄæ·s¼W¤@»²§UÄæ¡A¤½¦¡=C2&D2¡A¦V¤U½Æ»s
­pºâ­Ó¼Æªº¤½¦¡§ó§ï¬° =SUMPRODUCT((C2:C15="A")*(1/COUNTIF(E2:E15,E2:E15)))

TOP

¦^´_ 7# handsometrowa
¦¹¤½¦¡¬O¦b­pºâ¤£­«ÂЪº­Ó¼Æ¡A¦p¦³¬Û¦Pªº­Ó¼Æ¨ú­Ë¼Æ«á¦A¬Û¥[ªº­È´NÅܬ°1¡C¨Ò¦p¡G¦³¤G­Ó¶µ¥Ø¬Û¦P¡A«h­Ë¼Æ¬°0.5+0.5¡Aµ²ªG´N¬O1

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¤Hªº§Ö¼Ö¡D¤£¬O¦]¬°¥L¾Ö¦³±o¦h¡A¦Ó¬O¦]¬°¥L­p¸û±o¤Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD