½Ð°Ý¦¹¥\¯à¦³¨ä¥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
|
¦^´_ 20# Andy2483
¥i¬O°²³]§Ún«á±ªº®t¥h°µ¹Bºâ¡A¤]¬On©î¤@Äæ©ñ¼Æ¾Ú¤~¯à°µ¹Bºâ |
|
|
|
|
|
|
- ©«¤l
- 1446
- ¥DÃD
- 40
- ºëµØ
- 0
- ¿n¤À
- 1470
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Excel 2010 & 2016
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2020-7-15
- ³Ì«áµn¿ý
- 2024-10-21
|
¦^´_ 21# ÂŤÑÄR¦À
n¹B¥ÎÅܰʶq°µ¹Bºâ¥un¥Î
Split([B6],"__")(1) ´N¥i¥H¨ú±o¤F ¤£¥²©î¤@Äæ³á |
|
¥Î¦æ°Ê¸Ë¸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
|
¦^´_ 22# Andy2483
Andy½Ð±Ð§A¯àµ¹§ÚÓ§¹¾ãªºµ{¦¡§Ú¬P´Á¤@¸Õ¸Õ¬Ý¶Ü? |
|
|
|
|
|
|
- ©«¤l
- 1446
- ¥DÃD
- 40
- ºëµØ
- 0
- ¿n¤À
- 1470
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Excel 2010 & 2016
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2020-7-15
- ³Ì«áµn¿ý
- 2024-10-21
|
¦^´_ 23# ÂŤÑÄR¦À
§Ú¶ý¶ý¦í°|n¨ì¤U¬P´Á¤T¡A¤£¤è«K³B²z
¦pªG¨ãÅ骺Åܰʶqn°µ¤°¹Bºâ¦pªG¯à°÷¨ãÅ黡©ú©Î¤W¶Ç§ó§¹¾ãªº½d¨Ò
ª©¤W°ª¤â¶³¶°¤]³£¯à»P«e½ú°µ¥æ¬y |
|
¥Î¦æ°Ê¸Ë¸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
|
¦^´_ 24# Andy2483
¦n¡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
|
¦^´_ 24# Andy2483
Andy¦A¸ò§A½Ð±Ð¤@¤U¡A§Ú쥻¬Oªº·Qªk¬OB1©ñ¸ê®Æ¨Ó·½¡AC1·í»²§U®æ¡AA1=C1-B1¡AµM«áµ{¦¡¼g¦¨·íB1<>C1ªº®ÉÔ±NB1ªºÈ½Æ»s¨ìC1µM«á¬Û´î¡A¤§«áÀ°A1¦³Åܰʦb©¹¤U¬ö¿ý¡A«á¨Óµo²{³o¼Ë°µÈ·|¬Ûµ¥¡A¬Û´î·|¤@ª½µ¥©ó0¡A¦³¨S¦³Ãþ¦ü§Ú»¡ªº³oºØ¤è¦¡ªº¼gªk©O? |
|
|
|
|
|
|
- ©«¤l
- 1446
- ¥DÃD
- 40
- ºëµØ
- 0
- ¿n¤À
- 1470
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Excel 2010 & 2016
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2020-7-15
- ³Ì«áµn¿ý
- 2024-10-21
|
¦^´_ 26# ÂŤÑÄR¦À
¦pªG¬O³oºØÅÞ¿è§Úı±o
1.A1¦pªG¬O¬°¤FÅã¥Ü³Ì«áªº®tÈ¡A´N¤£n¦A¥Î¤½¦¡pºâ¡A¦]爲B1È´«¦ì¨ìC1®ÉA1¤½¦¡È³£¬O0¡AA1ȧï¥ÑVBAµ¹È
2. VBA¸Ì¼g¡G
¦pªG¸õ°ÊªºB1<>C1,´N¥OA1=B1-C1,¦A¥OC1=B1,³o¼Ëªº¤è¦¡¥u¦³B1ÅÜ°Ê®Éif §PÂ_¦¡¤~·|¦¨¥ß¡A¥BA1¤]¤£·|¬O0
³Ì«á§âA1Ȥ]¶ñ¤JAÄ檺²Ä¤@Ӫťծæ |
|
¥Î¦æ°Ê¸Ë¸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
|
¦^´_ 27# Andy2483
¦nªº¡A·PÁ |
|
|
|
|
|
|
- ©«¤l
- 2833
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 2889
- ÂI¦W
- 0
- §@·~¨t²Î
- ¡e²¤¡f
- ³nÅ骩¥»
- ¡e²¤¡f
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¡e²¤¡f
- µù¥U®É¶¡
- 2013-5-13
- ³Ì«áµn¿ý
- 2024-11-11
|
|
|
|
|
|
|
- ©«¤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
|
¦^´_ 27# Andy2483
Andy¡A½Ð±Ð¤@¤U¡A§Ú·Ó§Aªº¤è¦¡§ï¤F¤§«á·|¥X²{°ïÅ|ªÅ¶¡¤£¨¬ªº°ÝÃD¡A¯àÀ°§Ú¬Ý¤@¤U°ÝÃD¥X¦bþ¶Ü?
´ú¸Õ.rar (27.44 KB)
|
|
|
|
|
|
|