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

[µo°Ý] ©Þªe¤ñÁɹڤ۶¤¥î

[µo°Ý] ©Þªe¤ñÁɹڤ۶¤¥î

¦U¦ìª©¤WªB¤Í¤j®a¦n,¤@°_¾Ç²ß§a!
½Ð¨Ï¥Î½d¨ÒÀɮ׾ǥ͸ê®Æ,´£¨Ñ20¦W¾Ç¥Í¦W³æ°Ñ¥[¨k¤k²V¦X©Þªe¤ñÁÉ
1.¨S¦³¥¿½Tµª®×
2.¾Ç¥Í³£«Ü¦³¹B°Ê®aºë¯«,¦Ñ®v«Ü¦³¹Îµ²ºë¯«¾®»E¤O

©Þªe¤ñÁɹڤ۶¤¥î_1.zip (4.82 KB)

20230619_1.jpg
2023-6-19 08:36


¦¹¥DÃDAndy¥u¦^À³¬ÛÃö°ÝÃD,¤£§@µª,ÁܽФj®a¤@°_¾Ç²ß.°Q½×.«ü¾É.....
ÁÂÁ½׾Â,ÁÂÁ¤j®a
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

G2:I26{=IF(ROW(A1)>$E$2*2,"",INDEX(A:A,RIGHT(LARGE(MMULT(1-ISERR(FIND({"¨k","¤k"},$A$2:$A$27)),{1;2})*10^8+$C$2:$C$27*10^6+$B$2:$B$27/1%+ROW($2:$27),ROW(A1)+(ROW(A1)>$E$2)*(15-$E$2)),2)))
11457.png
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 2# hcm19522


    ÁÂÁÂ hcm19522
¤è®×°õ¦æµ²ªG¦p¤U:
20230621_1.jpg
2023-6-21 07:20
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@­Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ù­È¤]¨S¦³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD