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

huangwed

¦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ÁÂÁÂ!

¤U¸ü (82.59 KB)

2013-11-20 14:43

bmouth

¦bE2¦C¥´
=C2&":"&D2
¾ã¦C³£°µ

µM«á¦b F2 ¥´
=1/COUNTIF(E:E,E2)
¾ã¦C³£°µ

µM«á¥Î¥H¤U¤½¦¡´N¥i±o¥Xµª®×
=SUMIF(C:C,"A",F:F)

aer

¦^´_ 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

aer

¦^´_ 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)))

Hsieh

¦^´_ 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),))))

¤U¸ü (17.34 KB)

2013-11-21 10:55

handsometrowa

¦^´_ 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¤°»ò@@?

ML089

¦^´_ 1# huangwed


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

«D°}¦C¤è¦¡µ¥¤¤¤È¦³ªÅ¦A·Q¬Ý¬Ý

ML089

¦^´_ 3# huangwed


½Ðª`·N! 2¼Ó¤½¦¡¨Ï¥Î¬O¦³­­¨îªº¡A¥u¯à¦b¦Uµ¥¯Å¶¡¶µ¥Ø¤£¯à­«½Æ¡C
¨Ò¦p ¥þ³¡§ï¬° ­»¿¼ ®É¡Aµª®×¬O0.375

p212

¦^´_ 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

huangwed

¦^´_ 2# aer

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