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

[µo°Ý] Âà´«¤å¦r§Î¦¡·j´M

¦^´_ 13# wayne0303

½Ð¦A´ú¸Õ¬Ý¬Ý¡AÁÂÁÂ

   1.¦p¹Ï²{¦b¹J¨ì¥õ¨¤¬O­Ó¦ì¼Æ¦r¸òR¬°4¦ì¼Æ¦r´N·j´M¤£¨ì  >> ¤w§ó·s¦pªþ¥ó
   2.¦pªG§Úªºªí®æ¬O¥²»Ý¤Þ¥Î¨ì¥~³¡ªºªí®æ¨º§Ú­n§ï¥N½Xªº­þÃä©O¡H >> µ{¦¡½X¦³³Æµù»Ý­n§ó§ïªº¦a¤è(²Ä1¬q)
   3.¥Î"¼Ò²Õ"ªº¸Ü¦³¿ìªk«ö­Ó·Æ¹«ªº¥kÁä©Î¥ªÁä´N§ó·s¼Æ­È ©Î¬O ¼Æ­È¦³Åܧó´N¥i¥ß§Y§ó·s¼Æ­È(¤£»ÝÃö±¼ÀɮצA¶})¡H  >>¤w§ó·s¡A·íA5~A65536¦³§ó·s·|¦Û°Ê§ó·s

Âà´«¤å¦r§Î¦¡·j´M_0831.zip (394.62 KB)

TOP

¦^´_ 12# samwang


·PÁÂsamwang¤j¡I¦ý
   1.¦p¹Ï²{¦b¹J¨ì¥õ¨¤¬O­Ó¦ì¼Æ¦r¸òR¬°4¦ì¼Æ¦r´N·j´M¤£¨ì
   2.¦pªG§Úªºªí®æ¬O¥²»Ý¤Þ¥Î¨ì¥~³¡ªºªí®æ¨º§Ú­n§ï¥N½Xªº­þÃä©O¡H
   3.¥Î"¼Ò²Õ"ªº¸Ü¦³¿ìªk«ö­Ó·Æ¹«ªº¥kÁä©Î¥ªÁä´N§ó·s¼Æ­È ©Î¬O ¼Æ­È¦³Åܧó´N¥i¥ß§Y§ó·s¼Æ­È(¤£»ÝÃö±¼ÀɮצA¶})¡H

   ÁÂÁÂ

2021-08-31_081911.jpg (118.24 KB)

2021-08-31_081911.jpg

TOP

¥»©«³Ì«á¥Ñ samwang ©ó 2021-8-31 07:19 ½s¿è
¦^´_  samwang

³ø§isamwang¤j¡I
  §Ú°õ¦æ§¹¨SªF¦è吔...

R¬O3~4¦ì¼Æ¦r
wayne0303 µoªí©ó 2021-8-30 23:54


¦pªþ¥ó¹Ï¤ù¡A§Ú°õ¦æ¨S°ÝÃD¨Ì¾Ú4#µ{¦¡½X¡Aµ²ªG¦bBÄæ¡A½Ð¦A½T»{¡AÁÂÁ¡C

Â^¨ú1.PNG (137.39 KB)

Â^¨ú1.PNG

TOP

¥»©«³Ì«á¥Ñ wayne0303 ©ó 2021-8-31 00:09 ½s¿è

¦^´_ 4# samwang

³ø§isamwang¤j¡I
  §Ú°õ¦æ§¹¨SªF¦è吔...

R¬O3~4¦ì¼Æ¦r

TOP

¦pªG¬O¤Þ¥Î¨ä¥¦¤u§@ªí¬°·j´M¸ê®Æªº±¡ªp¤U¡A¦³¨ä¥¦¤½¦¡ªº¼gªk¶Ü¡H
R«á¼Æ¦r¬°3~4¦ì¼Æ

(¥ÎOFFSETªº¤½¦¡¡A¥²»Ý¶}±Ò¤Þ¥Îªº¤u§@ªí¡A¤£µM·|¥X²{#VALUE!)

TOP

¦^´_ 5# hcm19522



¤£¦n·N«ä­n¦A½Ð°Ý¤@¤Uhcm19522¤j¡I¦pªG§Úªº¼Æ¦r·|¨ì4¦ì¼Æ¨º¤½¦¡­n«ç»ò§ï¼g©O¡H

ÁÂÁÂ

TOP

¦^´_  hcm19522

½Ð±Ðhcm19522¤j¡I

§Ú¬O¨ú¨ä¥¦¤u§@ªíªº¸ê®Æ·j´M
¤Þ¥ÎC$1¡BD$1·|¦³¼vÅT¶Ü¡H¦]¬°§Ú·|¥X ...
wayne0303 µoªí©ó 2021-8-21 13:57



ÁÂÁÂhcm19522¤j¤j¡I

¤£¦n·N«ä¡A§Ú¬ÝÀ´¤F


ÁÂÁ±zªºÀ°¦£¡I¡I

TOP

¦^´_ 4# samwang


·PÁÂsamwang¤j¤jÀ°¦£¡I¡I

TOP

¦^´_ 5# hcm19522

½Ð±Ðhcm19522¤j¡I

§Ú¬O¨ú¨ä¥¦¤u§@ªíªº¸ê®Æ·j´M
¤Þ¥ÎC$1¡BD$1·|¦³¼vÅT¶Ü¡H¦]¬°§Ú·|¥X²{#N/A...

TOP

C5=OFFSET(C$1,IF(LEFT(A5)="L",8,IF(LEFT(A5,2)="RR",2,14)),MATCH(MID(SUBSTITUTE(A5,"¥õ¨¤","/"),1+(MID(A5,2,1)="R"),4+(MID(A5,2,1)="R")*3),OFFSET(D$1,IF(LEFT(A5)="L",9,IF(LEFT(A5,2)="RR",3,15)),,,20),))
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

        ÀR«ä¦Û¦b : ¹D¼w¬O´£ª@¦Û§Úªº©ú¿O¡A¤£¸Ó¬O¨þ¥¸§O¤HªºÃ@¤l¡C
ªð¦^¦Cªí ¤W¤@¥DÃD