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

[µo°Ý] Excel ¨ç¼ÆÂ^¨ú¦r¦ê°ÝÃD

[µo°Ý] Excel ¨ç¼ÆÂ^¨ú¦r¦ê°ÝÃD

1.png
2020-4-14 08:54

¦U¦ì¤j¤j¦n¡A§Ú·QÅý¥X¶Ô¤Ñ¼Æ¸Ì­±¨C­Ó¼Æ¦r¡A¹ïÀ³¨ì¥k¤èªºÄæ¦ì¡A
¨Ò¦p:¥X¶Ô¤Ñ¼Æ 16¥ð5¤½1¯f11.5¡A´N¬O16¤Ñ¤u§@¤Ñ¡B¯S¥ð11.1¡B¤½°²1¤Ñ¡B¯f°²11.5¤Ñ
¥Ø«e§Úªº·Qªk¬O¥Î¨ç¼Æ =mid("¥ð",1,1)
¤£¹L¤Ñ¼Æ¦³3ºØ±¡ªp1¦ì¼Æ¡B2¦ì¼Æ¡B3¦ì¼Æ¡A
½Ð¦U¦ìExcel ¤j¤j¸Ñ´b¡AÁÂÁ¡C

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 2# hcm19522
·PÁ¤j¤j! ¸g´ú¸Õ¥i¥H¨Ï¥Î!
¥t¥~¡AIFERROR(-LOOKUP(9,-MID($B2,FIND(RIGHT(C$1),"¤Ñ"&$B2),{1,2,3,4})),"")
§Ú¹ï³o¨ç¼Æ¦³µy·L¤ÀªR»{ÃÑ¡A¦p¦³¿ù»~¸ÑÄÀÁٷнФj¤jÀ°¦£§ó¥¿¡C
RIGHT(C$1) ¡÷³o­Ó¬O¥H¼ÐÃD¦C¡AÀ°§Ufind·j´M¥ð¡B¯f¡B³àªº¦r¦ê¦ì¸m
FIND(RIGHT(C$1),"¤Ñ"&$B2)   ¡÷·j´M¦ì¸m EX. 6¥ð5¤½1¯f11.5¡A ¥ðªº¸Ü¬O2
-MID($B2,FIND(RIGHT(C$1),"¤Ñ"&$B2),{1,2,3,4})
¡÷¥ÎMID¦C¥X¦r¦ê¨Ã¦C¥X4²Õªº°}¦C¡A6¥ð5¤½1¯f11.5¡A¥ðªº¸Ü¬O¡A{¥ð¡B¥ð5¡B¥ð5¤½¡B¥ð5¤½1}?
³oÀ³¸Ó¬O­n¦r¦êÂà´«¼Æ­Èªº¡A³o¦a¤è¤ñ¸û¤£À´¡AÁٽФj¤jÀ°¦£¸Ñµª¡C

TOP

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2020-4-14 15:38 ½s¿è

¦^´_ 3# mash071896


    ¥ÎMID¦C¥X¦r¦ê¨Ã¦C¥X4²Õªº°}¦C¡A6¥ð5¤½1¯f11.5¡A¥ðªº¸Ü¬O¡A{5,5¤½,5¤½1,5¤½1¯f}+ "-"-->{-5,¿ù,¿ù,¿ù}-->¨ú-5-->³Ì«e + "-"-->5
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 4# hcm19522
·PÁ¸ѵª!!
¥t¥~ÁÙ·Q¦A°Ý³Ì«á¤@­Ó¤½¦¡°ÝÃD¡A
¨Ì·Ó-MID¨ç¼Æ·|¶Çªº°}¦C¡A¥H¥ð11.5¬°¨Ò
¥Îlookup¬d§ä¡A
-lookup(9,{-1,-11,-11.,-11.5})¡A
-¬O¨Ï¨äµ²ªGÂॿ­È¡A
¤£¹Llookup¬d§ä¤£¬O§äµ¥©ó9©Î¤p©óªºªñ¦ü­È¡A
³o¼ËÀ³¸Ó¬O-1¡A§Ú¦³¥ÎEXCEL¶]³o¬q¡Aµ²ªG¬O-11.5¡A
·Q½Ð¤j¤jÀ°§ÚÂç²M³oÆ[©À¡A!

TOP

¦^´_ 5# mash071896


    ¤j¬A¸¹¸Ì­n¤É幂 ,­YµL¥B«e­±­È >¤j¬A¸¹¸Ì­È ,«h¨ú³Ì«á­È
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 6# hcm19522
·PÁ¤j¤j¸Ñµª!

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¤£¤@©w²y²y¬O¦n²y¡A¦ý¬O¦³¾ú½mªº±j¥´ªÌ¡AÀH®É³£¥i¥H´§´Î¡C
ªð¦^¦Cªí ¤W¤@¥DÃD