[µo°Ý]½Ð°Ý¡G²Å¦XAÄæ±ø¥ó¡A¥[Á`BÄ椧¤£«½ÆȪº¶µ¥ØÓ¼Æ
- ©«¤l
- 3
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 8
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN8
- ³nÅ骩¥»
- 2010
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taipei
- µù¥U®É¶¡
- 2013-6-15
- ³Ì«áµn¿ý
- 2016-3-9
|
[µ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ÁÂÁÂ!
|
|
|
|
|
|
|
- ©«¤l
- 3
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 8
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN8
- ³nÅ骩¥»
- 2010
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taipei
- µù¥U®É¶¡
- 2013-6-15
- ³Ì«áµn¿ý
- 2016-3-9
|
¦^´_ 2# aer
°Ú¡A§Ú¯u¬O½k¶î¡A§â³oÓ·Q±o¤Ó½ÆÂø¤F!
¸U¤À·PÁÂ~·PÁ¸U¤À~ |
|
|
|
|
|
|
- ©«¤l
- 618
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 663
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2025-1-2
  
|
¥»©«³Ì«á¥Ñ 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 |
|
|
|
|
|
|
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
     
|
¦^´_ 3# huangwed
½Ðª`·N! 2¼Ó¤½¦¡¨Ï¥Î¬O¦³¨îªº¡A¥u¯à¦b¦Uµ¥¯Å¶¡¶µ¥Ø¤£¯à«½Æ¡C
¨Ò¦p ¥þ³¡§ï¬° »¿¼ ®É¡Aµª®×¬O0.375 |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
     
|
¦^´_ 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¤½¦¡
|
|
|
|
|
- ©«¤l
- 82
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 112
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- WIN7
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-1-3
- ³Ì«áµn¿ý
- 2020-9-21
|
¦^´_ 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¤°»ò@@? |
|
|
|
|
|
|
- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 44
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2025-2-20
               
|
¥»©«³Ì«á¥Ñ 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°Ý
|
|
|
|
|