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

[µo°Ý] ½Ð°ÝEXCEL«ç»ò¨ú±o¤u§@ªíªº¼Æ¶q»P¸ê®Æ¦æ¼Æ©O(¸ó¤u§@ªí)!?ÁÂÁÂ

¦^´_  konkon3141
¤º®e´N¬O¦bC10 ¶ñ¤J¤½¦¡
=COUNTA(¶}©l¤u§@ªí:µ²§ô¤u§@ªí!B:B)-COUNTA(¶}©l¤u§@ªí:µ²§ô ...
stillfish00 µoªí©ó 2012-10-28 19:15



    ¤j¤j³o¬O§ÚªºÀÉ®×
    ¼Ò¨ã¼i¾ú.rar (33.4 KB)
    ½Ð¤j¤jÀ°§Ú¬Ý¤@¤U
    §ÚÅv­­¤£°÷¤j¤j³B²z¦n¥i¥H¶Ç¨ìºô¸ôªÅ¶¡¶ÜQ.Q...
     «ô°U¤F~~ÁÂÁÂ^^

TOP

¦^´_ 11# konkon3141
http://d.pr/f/Sxsz

³Ì«áµo²{°ÝÃD¦b¤u§@ªí¦WºÙ¦³§t¬A¸¹ , ©Ò¥H¦b¨Ï¥Î¤½¦¡®É¤u§@ªí¦WºÙ­n¥t¥~¥[³æ¤Þ¸¹¤~¤£·|¥X¿ù
°Ú°Ú~³oºâ§Ú¨S¾i¦¨¨}¦n²ßºD°Õ><

TOP

¦^´_  konkon3141
http://d.pr/f/Sxsz

³Ì«áµo²{°ÝÃD¦b¤u§@ªí¦WºÙ¦³§t¬A¸¹ , ©Ò¥H¦b¨Ï¥Î¤½¦¡®É¤u§@ªí¦W ...
stillfish00 µoªí©ó 2012-10-28 21:20



    ¤j¤j§Ú§â( ) + &¥þ§ï¦¨-
    µ²ªG¤Á´«¨ì¥Ø¿ý¥L¤@ª½­n§Ú¶}±ÒÀÉ®×= ="
    ¦Ó¥B¿é¤J¸ê®Æ¤]¤£·|§ó·sµ§¼Æ..
    http://www.mediafire.com/?s6eqfqc4dj3wlz9
    ¥t¥~¬°¬Æ»ò¤u§@ªí¦WºÙ¤£¯à¨Ï¥Î( )©O!?
    ¦A¦¹¥ýÁÂÁ¤j¤jªºÀ°¦£^^~~

TOP

¦^´_ 13# konkon3141
http://d.pr/f/Sxsz ³o­ÓÀɮפ£¯à¥Î¶Ü? ³o¬O§ï¹Lªº

TOP

¦^´_  konkon3141
http://d.pr/f/Sxsz ³o­ÓÀɮפ£¯à¥Î¶Ü? ³o¬O§ï¹Lªº
stillfish00 µoªí©ó 2012-10-28 21:44



³o­Ó¥i¥H¤F!!!
¤j¤j¦³§ï¤u§@ªí¦WºÙ¶Ü!?
¦n¹³¨S¦³§ï­C~~
¨S¦³§ï¤u§@¬O«ç»ò¸Ñ¨M³o­Ó°ÝÃD©O!?
¦bEYNY¦³¤H»¡¤u§@ªí()·|³y¦¨VBA¤Þ¥ÎÀx¦s®æ¯à°÷¥Îªº¨ç¼Æ
©Ò¥H«Ü¥i¯à·|²V²c
¦A¦¹·PÁ¤j¤jªºÀ°¦£^^~~
¾Ç²ß¨ì«Ü¦hEXCELªºª¾ÃÑ

TOP

¥t¥~½Ð°Ý¤j¤j§Ú·Q§â²Ä3¤u§@ªí"PC°w¼Ò"~·s¤â¿ö¬[(²Õ)ÁôÂÃ
¦ý³o¼Ë·|³y¦¨²Ä1­¶ªº¼Æ¶qµLªk­pºâ­C...
¥Ø¿ý¤U¤èªº¶W³sµ²¤]·|¥þ³¡¥¢®Ä..

TOP

¦^´_ 13# konkon3141

¦Û©w¸q¨ç¼Æ
  1. Function All_Data(sh As Range, sh1 As Range, MyType As Integer) As Double
  2. Application.Volatile
  3. For Each sht In Sheets
  4.   If sht.Name <> sh.Parent.Name And sht.Name <> sh1.Parent.Name Then
  5.      Rng = sh.Address(, , , , 0)
  6.      Rng1 = sh1.Address(, , , , 0)
  7.      Select Case MyType
  8.      Case 0
  9.      All_Data = All_Data + 1
  10.      Case Else
  11.      All_Data = All_Data + (Application.CountA(sht.Range(Rng)) - Application.CountA(sht.Range(Rng1)))
  12.      End Select
  13.   End If
  14. Next
  15. End Function
½Æ»s¥N½X
C9=All_Data(A1,ªÅ¥Õ®æ¦¡!A1,0)
C10=All_Data('¥Ø¿ý&¼Ò¨ã«~¦W'!B:B,ªÅ¥Õ®æ¦¡!B$1:B$8,1)
C11=All_Data('¥Ø¿ý&¼Ò¨ã«~¦W'!J:J,ªÅ¥Õ®æ¦¡!J$1:J$8,1)
C12=All_Data('¥Ø¿ý&¼Ò¨ã«~¦W'!P:P,ªÅ¥Õ®æ¦¡!P$1:P$8,1)
¼Ò¨ã¼i¾ú.rar (46.42 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_  konkon3141

¦Û©w¸q¨ç¼ÆC9=All_Data(A1,ªÅ¥Õ®æ¦¡!A1,0)
C10=All_Data('¥Ø¿ý&¼Ò¨ã«~¦W'!B:B,ªÅ¥Õ®æ ...
Hsieh µoªí©ó 2012-10-28 22:31



¤j¤j§Ú½×¾ÂÅv­­¤£°÷
¥i¥H¶Çºô¸ôªÅ¶¡¶Ü@@!?
ÁÂÁÂÅo^^~~~

TOP

¦^´_ 16# konkon3141
ÁôÂäu§@ªíªº¶W³sµ²·|¥¢®Ä¬O¥¿±`ªº..
¥t¤@ºØ¤èªk¬O¤u§@ªí¤£ÁôÂà , ¨ìExcel¿ï¶µ¸Ì¨ú®ø ¤u§@ªí¯Á¤Þ¼ÐÅÒ
¤£¹L¬Ý¥Î³~°Õ  ¦³®É­Ô·|¤£¤Ó¤è«K..

TOP

¦^´_  konkon3141
ÁôÂäu§@ªíªº¶W³sµ²·|¥¢®Ä¬O¥¿±`ªº..
¥t¤@ºØ¤èªk¬O¤u§@ªí¤£ÁôÂà , ¨ìExcel¿ï¶µ¸Ì¨ú®ø  ...
stillfish00 µoªí©ó 2012-10-28 23:15



¦b¨Ì²ú¦³¤j¤j»¡¦pªG¶û¤Uªí¤u§@ªí¯Á¤Þ¼ÐÅÒ¤Ó¦h
¥i¥H¦Ò¼{¥HÀɮ׳sµ²ªº¤è¦¡
¥H§Ú³o­Ó¨Ò¤l
´N¤£ª¾¹D¦³¨S¦³1­Ó¤u§@ªí´«¦¨1­Ó¬¡­¶Ã¯ªº¤èªk¤F
¦Ó¥B¦b¥Ø¿ýªº²Î­p¶q¦³¿ìªk¸óÀÉ®×­pºâ¶Ü...³o¤]¬O­Ó¤j°ÝÃD

¨ú®ø¤u§@ªí¯Á¤Þ¼ÐÅÒÁÙÆZ¤£¤è«Kªº@@
¦pªG­n·s¼W¤u§@ªí«á­n¦^ªÅ¥Õ®æ¦¡ ½Æ»s®æ¦¡
¯uªº«D±`³Â·Ð..

·PÁ¤j¤jªá¤F1¤Ñ¼ö¤ßªºÀ°¦£^^~~
¾Ç¨ì¤F«Ü¦h¬O¾Ç®Õ¤£·|±Ðªºª¾ÃÑ~~

TOP

        ÀR«ä¦Û¦b : ¡i°±º¢¤£«e¡A²×µL©Ò±o¡j¤H³£°g©ó´M§ä©_ÂÝ¡A¦]¦Ó°±º¢¤£«e¡FÁa¨Ï®É¶¡¦A¦h¡B¸ô¦Aªø¡A¤]¤FµL¥Î³B¡A²×µL©Ò±o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD