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

[¤À¨É] ¤@¨Ç¨ç¼Æªº¥¿½T¥Îªk

[¤À¨É] ¤@¨Ç¨ç¼Æªº¥¿½T¥Îªk

¤@¨Ç¨ç¼Æªº¥¿½T¥Îªk
1¡B¨â¦C¼Æ¾Ú¬d§ä¬Û¦P­È¹ïÀ³ªº¦ì¸m
=MATCH(B1,A:A¡A0)
2¡B¤wª¾¤½¦¡±oµ²ªG
©w¸q¦WºÙ=EVALUATE(Sheet1!C1)
¤wª¾µ²ªG±o¤½¦¡
©w¸q¦WºÙ=GET.CELL(6,Sheet1!C1)
3¡B±j¨î´«¦æ
¥ÎAlt+Enter
4¡B¶W¹L15¦ì¼Æ¦r¿é¤J
³o­Ó°ÝÃD°Ýªº¤H¤Ó¦h¤F¡A¤]¦¬°_¨Ó§a¡C¤@¡B³æ¤¸®æ³]¸m¬°¤å¥»;¤G¡B¦b¿é¤J¼Æ¦r«e¥ý¿é¤J'
5¡B¦pªGÁôÂäFB¦C¡A¦pªGÅý¥¦Åã¥Ü¥X¨Ó?
¿ï¤¤A¨ìC¦C¡AÂIÀ»¥kÁä¡A¨ú®øÁôÂÃ
¿ï¤¤A¨ìC¦C¡AÂùÀ»¿ï¤¤¥ô¤@¦C¼e½u©Î§ïÅÜ¥ô¤@¦C¼e
±N¹«¼Ð²¾¨ì¨ìAC¦C¤§¶¡¡Aµ¥¹«¼ÐÅܬ°Âù½Ý½u®É©ì°Ê¤§¡C
6¡BEXCEL¤¤¦æ¦C¤¬´«
½Æ»s¡A¿ï¾Ü©ÊÖ߶K¡A¿ï¤¤Âà¸m¡A½T©w§Y¥i
7¡BExcel¬O«ç»ò¥[±Kªº
¡]1¡^¡B«O¦s®É¥i¥Hªº¥t¦s¬°>>¥k¤W¨¤ªº"¤u¨ã">>±`³W>>³]¸m
¡]2¡^¡B¤u¨ã>>¿ï¶µ>>¦w¥þ©Ê
8¡BÃö©óCOUNTIF
COUNTIF¨ç¼Æ¥u¯à¦³¤@­Ó±ø¥ó¡A¦p¤j©ó90¡A¬°=COUNTIF(A1:A10,">=90")
¤¶©ó80»P90¤§¶¡»Ý¥Î´î¡A¬° =COUNTIF(A1:A10,">80")-COUNTIF(A1:A10,">90")
9¡B®Ú¾Ú¨­¥÷ÃÒ¸¹´£¨ú¥X¥Í¤é´Á
¡]1¡^¡B=IF(LEN(A1)=18,DATE(MID(A1,7,4),MID(A1,11,2),MID(A1,13,2)),IF(LEN(A1)=15,DATE(MID(A1,7,2),MID(A1,9,2),MID(A1,11,2)),"¿ù»~¨­¥÷ÃÒ¸¹"))
¡]2¡^¡B=TEXT(MID(A2,7,6+(LEN(A2)=18)*2),"#-00-00")*1
10¡B·Q¦bSHEET2¤¤§¹¥þ¤Þ¥ÎSHEET1¿é¤Jªº¼Æ¾Ú
¤u§@²Õ¡A«ö¦íShift©ÎCtrlÁä¡A¦P®É¿ï©wSheet1¡BSheet2¡C
11¡B¤@¦C¤¤¤£¿é¤J­«½Æ¼Æ¦r
[¼Æ¾Ú]--[¦³®Ä©Ê]--[¦Û©w¸q]--[¤½¦¡]
¿é¤J=COUNTIF(A:A,A1)=1
¦pªG­n¬d§ä­«½Æ¿é¤Jªº¼Æ¦r
±ø¥ó®æ¦¡¡n¤½¦¡¡n=COUNTIF(A:A,A5)>1¡n®æ¦¡¿ï¬õ¦â
12¡Bª½±µ¥´¶}¤@­Ó¹q¤lªí®æ¤å¥óªº®É­Ô¥´¤£¶}
¡u¤å¥ó§¨¿ï¶µ¡v-¡u¤å¥óÃþ«¬¡v¤¤§ä¨ì.XLS¤å¥ó¡A¨Ã¦b¡u°ª¯Å¡v¤¤½T»{¬O§_¦³°Ñ¼Æ1%,¦pªG¨S¦³¡A½Ð¤â¤u¥[¤W
13¡Bexcel¤U©Ôµæ³æªº¹ê²{
[¼Æ¾Ú]-[¦³®Ä©Ê]-[§Ç¦C]
14¡B 10¦C¼Æ¾Ú¦X­p¦¨¤@¦C
=SUM(OFFSET($1,(ROW()-2)*10+1,,10,1))
15¡B¬d§ä¼Æ¾Ú¤½¦¡¨â­Ó(°ò¥»¬d§ä¨ç¼Æ¬°VLOOKUP,MATCH)
¡]1¡^¡B®Ú¾Ú²Å¦X¦æ¦C¨â­Ó±ø¥ó¬d§ä¹ïÀ³µ²ªG
=VLOOKUP(H1¡AA1¡GE7¡AMATCH(I1¡AA1¡GE1¡A0)¡AFALSE)
¡]2¡^¡B®Ú¾Ú²Å¦X¨â¦C¼Æ¾Ú¬d§ä¹ïÀ³µ²ªG(¬°¼Æ²Õ¤½¦¡)
=INDEX(C1¡GC7¡AMATCH(H1&I1,A1:A7&B1:B7,0))
16¡B¦p¦óÁôÂó椸®æ¤¤ªº0
³æ¤¸®æ®æ¦¡¦Û©w¸q0;-0;;@ ©Î ¿ï¶µ¡nµø¹Ï¡n¹s­È¥h¤Ä¡C¨þ¨þ¡A¦pªG¥Î¤½¦¡´N­n¬Ý±¡ªp¤F¡C
17¡B¦h­Ó¤u§@ªíªº³æ¤¸®æ¦X¨Ö­pºâ
=Sheet1!D4+Sheet2!D4+Sheet3!D4¡A§ó¦nªº=SUM(Sheet1:Sheet3!D4)
18¡BÀò±o¤u§@ªí¦WºÙ
¡]1¡^¡B©w¸q¦WºÙ¡GName
=GET.DOCUMENT(88)
¡]2¡^¡B©w¸q¦WºÙ¡GPath
=GET.DOCUMENT(2)
¡]3¡^¡B¦bA1¤¤¿é¤J=CELL("filename")±o¨ì¸ô®|¯Å¤å¥ó¦W
¦b»Ý­n±o¨ì¤å¥ó¦Wªº³æ¤¸®æ¿é¤J
=MID(A1,FIND("*",SUBSTITUTE(A1,"","*",LEN(A1)-LEN(SUBSTITUTE(A1,"",""))))+1,LEN(A1))
¡]4¡^¡B¦Û©w¸q¨ç¼Æ
Public Function name()
Dim filename As String
filename = ActiveWorkbook.name
name = filename

¦^´_ 1# thjh159


    ·PÁª©¥D¤À¨É,¦ý¨ä¤¤²Ä9±ø,®Ú¾Ú¨­¥÷ÃÒ¸¹´£¨ú¥X¥Í¤é´Á,¦ü¥G³£¬OÅã¥Ü"¿ù»~¨­¥÷ÃÒ¸¹",½Ð°Ý¨ç¼Æ¬O§_¦³¿ù»~,ÁÂÁÂ!!

TOP

¦^´_ 1# thjh159

·PÁ¤À¨É¯µ§Þ, ¦ý¦P2¼Ó¦P¾Ç¤@¼Ë, ¥Ñ¨­¤ÀÃÒ¸¹, µLªk¨ú±o¤é´Á.

TOP

¨­¤ÀÃÒ´£¨ú¥X¥Í¤é´ÁÀ³¸Ó¬O¤¤°ê¤j³°ª©¥»

TOP

«D±`¹ê¥Î~·PÁÂ!

TOP

        ÀR«ä¦Û¦b : ¯¸¦b¥b¸ô¡A¤ñ¨«¨ì¥Ø¼Ð§ó¨¯­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD