½Ð°Ý¦¹¥\¯à¦³¨ä¥Lªº¤è¦¡¸Ñ¨M¶Ü?
- ©«¤l
- 365
- ¥DÃD
- 40
- ºëµØ
- 0
- ¿n¤À
- 406
- ÂI¦W
- 0
- §@·~¨t²Î
- Win 7
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2012-12-11
- ³Ì«áµn¿ý
- 2024-8-24
|
½Ð°Ý¦¹¥\¯à¦³¨ä¥Lªº¤è¦¡¸Ñ¨M¶Ü?
¥»©«³Ì«á¥Ñ ÂŤÑÄR¦À ©ó 2024-1-2 21:33 ½s¿è
½Ð±Ðª©¤W«e½ú¡A§Ú¥Ø«e¦³ÓVBA¥Î¨Ó°O¿ý´Á³f¼Æ¾Ú¡A¨ä¥\¯à¬°¦¨¥æ¶q¦³ÅÜ°Ê´N¬ö¿ý¡AµM«á§Ú¥h°µpºâ¡A¥Ø«e¬O¥Î¦¨¥æ¶q¦³ÅÜ°Ê´N¬ö¿ýªº¤è¦¡¥h¼g¡A¦ý´Á³fªº¸õ°Ê³t«×«Ü§Ö(¦³®ÉÔ1¬í·|¼g¤J6-8µ§ªº¸ê®Æ)¡A±q¶}½L¨ì¦¬½L·|¼g¤J¤j¶qªº¸ê®Æ
¥Ø«e§ÚªºVBAªº¹B§@¦p¤U(A1ªºÈ¬O¨é°ÓDDE±o¨Óªº¡A¤j·§´N¦p¦P§Úªþ¥ó¨º¼Ë)
A1 10
A2 15 B2 = A2-A1 =5
A3 18 B3 = A3-A2 =3
A4 20 .
A5 25 .
. .
. .
¨Ì¦¸¤U¥h ¨Ì¦¸¤U¥h
¦]¬°§Ú§ìªº¸ê®Æ¤£¤Ö©Ò¥H¸ê®Æ¦³ÂI¤j¡A¥Ø«e¬O¥ý±N¸ê®Æ³£¥ý°O¿ý¤U¨Ó¡A¦A¨D®t¡A¾ÉP¹Bºâ³t«×ÅܺC¡A©Ò¥H·Q½Ð±Ðª©¤W«e½ú¡A§Ú¤Wzªº»Ý¨D¦pªG¤£¥ÎÅܰʼg¤Jªº¤è¦¡¥h¨D®t¡A¦³¨ä¥Lªº¸Ñ¨M¤è¦¡¶Ü? |
|
|
|
|
|
|
- ©«¤l
- 1447
- ¥DÃD
- 40
- ºëµØ
- 0
- ¿n¤À
- 1471
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Excel 2010 & 2016
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2020-7-15
- ³Ì«áµn¿ý
- 2024-12-5
|
¦^´_ 1# ÂŤÑÄR¦À
ÁÂÁ«e½úµoªí¦¹¥DÃD»P½d¨Ò
«e½ú±Ôzªº±¡¹Ò»P½d¨Ò¤£¤@¼Ë,¥i¥H¦A¸É¥R¤@¤U?
|
|
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y
|
|
|
|
|
- ©«¤l
- 365
- ¥DÃD
- 40
- ºëµØ
- 0
- ¿n¤À
- 406
- ÂI¦W
- 0
- §@·~¨t²Î
- Win 7
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2012-12-11
- ³Ì«áµn¿ý
- 2024-8-24
|
¦^´_ 2# Andy2483
¥Dn´N¬O¤£n¥Î¬ö¿ýªº¤è¦¡¨D®tÈ¡A·Q¤F¸Ñ¦³µL¨ä¥L¤è¦¡
ÀH®É¶¡±À¶iB¡BCÄæ·|¦³È¤@ª½¼g¶i¥h¡AµM«á¦A¨DB3-B2¡BB4-B3......¤@ª½¤U¥h
¸Ô²Ó»¡´N¬O°²³]B2¦b84500(®É¶¡)ªºÈ¬O252¡A84501ªºÈ¬O300¡A§Ú·Qn¨D®tÈ300-252¡A¦ý¤£·Q¥Î¬ö¿ýªº¤è¦¡¨D®tÈn¦p¦ó°µ©O? |
|
|
|
|
|
|
- ©«¤l
- 1447
- ¥DÃD
- 40
- ºëµØ
- 0
- ¿n¤À
- 1471
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Excel 2010 & 2016
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2020-7-15
- ³Ì«áµn¿ý
- 2024-12-5
|
¦^´_ 3# ÂŤÑÄR¦À
ÁÂÁ«e½ú¦^´_
«á¾Ç«Ü·Q¾ÇDDE, Worksheet.Calculate ¨Æ¥ó (Excel) «ç»òÀ³¥Î
¤u§@»â°ì¤£¦b³o°Ï¶ô,©|¥¼¬ã¨s,½Ð«e½úµyµ¥¨ä¥L¼F®`ªº«e½úÀ°¦£ |
|
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y
|
|
|
|
|
- ©«¤l
- 1447
- ¥DÃD
- 40
- ºëµØ
- 0
- ¿n¤À
- 1471
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Excel 2010 & 2016
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2020-7-15
- ³Ì«áµn¿ý
- 2024-12-5
|
¥»©«³Ì«á¥Ñ Andy2483 ©ó 2024-1-4 14:23 ½s¿è
¦^´_ 3# ÂŤÑÄR¦À
ÁÂÁ«e½ú
«á¾Ç¾Ç²ß Private Sub Worksheet_Calculate()¤è®×¦p¤U,½Ð«e½ú°Ñ¦Ò
¼ÒÀÀµ²ªG:
½d¨ÒÀÉ:
Åܰʬö¿ý_20240104.zip (17.29 KB)
|
|
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y
|
|
|
|
|
- ©«¤l
- 1388
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 1398
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-9-11
- ³Ì«áµn¿ý
- 2024-12-6
|
=SUMPRODUCT(N(OFFSET(A1,LOOKUP(1,0/(A:A<>""),ROW(A:A))-{1,2},))*{1,-1}) |
|
google"EXCEL°g" blog ©Îgoogleºô§}:https://hcm19522.blogspot.com/
|
|
|
|
|
- ©«¤l
- 365
- ¥DÃD
- 40
- ºëµØ
- 0
- ¿n¤À
- 406
- ÂI¦W
- 0
- §@·~¨t²Î
- Win 7
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2012-12-11
- ³Ì«áµn¿ý
- 2024-8-24
|
¦^´_ 6# hcm19522
½Ð±Ð«e½ú³o¬O¥Î¨ç¼Æªº¤è¦¡¨Ó¸Ñ¡H¯àÀ°§Ú¸ÑÄÀ¤@¤U¶Ü¡H¦³ÂI¬Ý¤£À´¡A·PÁ |
|
|
|
|
|
|
- ©«¤l
- 365
- ¥DÃD
- 40
- ºëµØ
- 0
- ¿n¤À
- 406
- ÂI¦W
- 0
- §@·~¨t²Î
- Win 7
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2012-12-11
- ³Ì«áµn¿ý
- 2024-8-24
|
¦^´_ 5# Andy2483
§Ú¦^®a¸Õ¸Õ¬Ý¡A¦A¸ò§A»¡µ²ªG |
|
|
|
|
|
|
- ©«¤l
- 365
- ¥DÃD
- 40
- ºëµØ
- 0
- ¿n¤À
- 406
- ÂI¦W
- 0
- §@·~¨t²Î
- Win 7
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2012-12-11
- ³Ì«áµn¿ý
- 2024-8-24
|
¥»©«³Ì«á¥Ñ ÂŤÑÄR¦À ©ó 2024-1-4 20:29 ½s¿è
¦^´_ 5# Andy2483
Andy¡A·PÁ§Aªº¦^ÂСA¦ý§A¦n¹³»~¸Ñ§Úªº·N«ä¤F¡A§A¥H¤Uªºµ{¦¡½XÁÙ¬O»Ýn§âÁ`©e½æ¸òÁ`©e½æ©¹¤U¼g¤~¯à¥h¬Û´î±o¥X®t¡A³o¼Ë¦pªG§Ú¦³20ÓÁ`©e¶R½æªº¸ê®Æ´N·|¦³40Äæ¡A¸ê®Æ¶q·|«Ü¤j
[F2] = [B2] - Cells(Rows.Count, 2).End(3)
[G2] = [C2] - Cells(Rows.Count, 3).End(3)
§Únªºµ²ªG¬O§Ú©¹¤U¼gªºÈ¥u¯d®tÈ¡A¦p¦P§Ú¦bªþ¥óÀ°§A¼Ð¥Üªº¼Ë¤l
Åܰʬö¿ý(®t§O).rar (19.58 KB)
|
|
|
|
|
|
|
- ©«¤l
- 1447
- ¥DÃD
- 40
- ºëµØ
- 0
- ¿n¤À
- 1471
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Excel 2010 & 2016
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2020-7-15
- ³Ì«áµn¿ý
- 2024-12-5
|
¦^´_ 9# ÂŤÑÄR¦À
ÁÂÁ«e½ú¦^ÂÐ
©ú¤Ñ¦A¤U¸ü¨Ó¬ã¨s¬Ý¬Ý |
|
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y
|
|
|
|
|