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

[µo°Ý] ¤U©Ô¿ï³æ¼Ò½k·j´M«á¬Û¦P¦WºÙ¤£¦P­È¤§§x´b...

[µo°Ý] ¤U©Ô¿ï³æ¼Ò½k·j´M«á¬Û¦P¦WºÙ¤£¦P­È¤§§x´b...

¦³¤@®M¦Lªí³æ
¤U©Ô¿ï³æ¼Ò½k·j´M«á¬Û¦P¦WºÙ¤£¦P­È¤§§x´b...
©Ò»Ý«È¤á°ò¥»¸ê®Æ¤¤¤á¦W¦³¬Û¦P¤§«È¤á¾Ö¦³¤£¦P¤§±b¸¹
¦p¤U¹Ï©Ò¥Ü:



¦b®M¦Lªí³æ¤¤¡A¥ý¦b A4 ½s¿è°Ï¿é¤J©Ò»Ý¤á¦W ¥ÃÂ× ¤§¬ÛÃö¦r·j´M...


¸g¼Ò½k·j´M¥X²{ 4 µ§²Å¦X¥ÃÂ׬ÛÃö¦r¤§¤á¦W¡A¦]©Ò»Ý¥¿½T¤á¦W¬O ¥ÃÂ×°Ó·~»È¦æªÑ¥÷¦³­­¤½¥q
¦]«È¤á°ò¥»¸ê®Æ¤¤¤á¦W ¥ÃÂ×°Ó·~»È¦æªÑ¥÷¦³­­¤½¥q ¾Ö¦³ 3 µ§¤£¦P±b¸¹¤§»È¦æ±b¸¹
¸Ó¤U©Ô¿ï³æ¸Ó¦p¦ó³]­p
Åý¬Û¦P¤§¤á¦W¿ï¾Ü®É(¯à¦b¤U©Ôªí³æ¿ï¾Ü®É¥X²{´£¥Ü±b¸¹¤§Åã¥Ü¶Ü?...¤ñ¸û®e©ö¿ï¾Ü·Q®M¦L¤§¤á¦W¤Î±b¸¹)
¤~¯àÂI¿ï¥¿½T¸Óµ§¤§¹ïÀ³±b¸¹
®M¦L®É¥X²{ ¥ÃÂ×°Ó·~»È¦æªÑ¥÷¦³­­¤½¥q ¬O¥²­n¤å¦r(¤á¦W)   



(°ÝÃD­«ÂI¦b©ó¬Û¦P¤á¦W¦hµ§¸ê®Æ¡A¥u¯à¥X²{¹ïÀ³ªº²Ä¤@µ§¸ê®Æ±b¸¹...¸Ó¦p¦ó­×¥¿¤½¦¡¤~¯àÅý©Ò¿ï¤§¤á¦W¹ïÀ³©Ò«Ø¤§±b¸¹¡B»È¦æ¡B¤À¦æ¤Îª÷¿Ä¥N½X)

1110506.rar (172.6 KB)

¥»©«³Ì«á¥Ñ zz5151353 ©ó 2022-5-21 12:55 ½s¿è

¤u§@ªí¦WºÙ : ³æ
S8 Àx¦s¤½¦¡¤U©Ô
  1. =IFERROR(INDEX(«È¤á°ò¥»¸ê®Æ!D:D,AGGREGATE(15,6,ROW($2:$1501)/(«È¤á°ò¥»¸ê®Æ!$C$2:$C$1501=$A$4),ROW(1:1))),"")
½Æ»s¥N½X
A3 Àx¦s®æ¤½¦¡
¼Æ¾Ú¦³®Ä©Ê¤½¦¡
  1. =OFFSET($S$8,,,COUNTIF($S$8:$S$65536,"<>"))
½Æ»s¥N½X

1110506.rar (181.16 KB)

300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¼Ò½k¬d§ä
Q7 ¿é¤J ¥ÃÂ×

Q8 Àx¦s®æ¤½¦¡¤½¦¡,¤U©Ô
  1. =IFERROR(INDEX(«È¤á°ò¥»¸ê®Æ!C:C,AGGREGATE(15,6,ROW($2:$1501)/((ISNUMBER(FIND($Q$7,«È¤á°ò¥»¸ê®Æ!$C$2:$C$1501)))*(--MATCH(«È¤á°ò¥»¸ê®Æ!$C$2:$C$1501,«È¤á°ò¥»¸ê®Æ!$C$2:$C$1501,)=ROW($1:$1500))),ROW(1:1))),"")
½Æ»s¥N½X
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 3# zz5151353
«D±`·PÁ ª©¥D zz5151353   ¼ö¤ß¦^ÂÐ
Ãö©ó¨Ì·Ó©Ò¥Ü

¼Ò½k¬d§ä
Q7 ¿é¤J ¥ÃÂ×

Q8 Àx¦s®æ¤½¦¡¤½¦¡,¤U©Ô
1.        =IFERROR(INDEX(«È¤á°ò¥»¸ê®Æ!C:C,AGGREGATE(15,6,ROW($2:$1501)/((ISNUMBER(FIND($Q$7,«È¤á°ò¥»¸ê®Æ!$C$2:$C$1501)))*(--MATCH(«È¤á°ò¥»¸ê®Æ!$C$2:$C$1501,«È¤á°ò¥»¸ê®Æ!$C$2:$C$1501,)=ROW($1:$1500))),ROW(1:1))),"")

¸g¹ê´ú¯àÅã¥Ü¬ÛÃö¥ÃÂפ§¤á¦W¦WºÙ
½Ð°ÝQ8 Àx¦s®æ¤½¦¡¤½¦¡¤U©Ô¬O§_¯à¥¿½TÅã¥Ü©ó«È¤á°ò¥»¸ê®Æ¬ÛÃö¥ÃÂפ§¤á¦W¥þ³¡§¹¾ã§e²{¤§µ§¼Æ¡K4µ§

TOP

¦^´_ 4# cypd

­ìÀɤw¦³»²§UÄæ¥i¥Î//
Xl0000074.rar (48.62 KB)

TOP

¦^´_ 5# ­ã´£³¡ªL
«D±`·PÁ  ­ã´£³¡ªL  ªº«ü¾É ...^^


§Æ±æ A3 Àx¦s®æ®æ¦¡¯à¹³ A8 ¤@¼Ëªº¶¡®æ(¦]®M¦Lªí³æ¦ì¸m©Ò»Ý)
¦r«¬ Arial Narrow 20
½Ð°Ý­ì A3¤½¦¡...MID(Q7,FIND("_",Q7&"_")+1,99) ¸Ó¦p¦ó­×¥¿¤~¯à²Å¦X¸Ó¼Ë¦¡?

0603.rar (47.78 KB)

TOP

¦^´_ 6# cypd

¶}ÀY¦³0//
=TRIM(TEXT(MID(Q7,FIND("_",Q7&"_")+1,99),REPT("0 ",MAX(,LEN(Q7)-FIND("_",Q7&"_")))))

¶}ÀY¨S0
=TRIM(TEXT(MID(Q7,FIND("_",Q7&"_")+1,99),REPT("# ",14)))

±b¸¹³Ì¦h14½X

TOP

¦^´_ 7# ­ã´£³¡ªL

«D±`·PÁ  ­ã´£³¡ªL  ªº«ü¾É ...^^

°w¹ï©Ò¦^ÂФ§¬ÛÃö¤½¦¡...
¥u¿é¤J²µu¤å¦r©Î¼Æ¦r,¥H¦WºÙ©Î±b¸¹¬d¸ß...¥¿¬O©Ò»Ý¤§®ÄªG

¨Ã¦Ò¶q±b¸¹³Ì¦h14½X
¶}ÀY¦³0//...¦]¨C®a¾÷ºc½X¼Æ¤£¦P©Ò¦Ü
=TRIM(TEXT(MID(Q7,FIND("_",Q7&"_")+1,99),REPT("0 ",MAX(,LEN(Q7)-FIND("_",Q7&"_")))))
©Ò­z°ÝÃD¤wÀò¸Ñ´b...·P®¦

TOP

¦^´_ 1# cypd

¤£¦n·N«ä¦U¦ì¥ý¶i...
°w¹ïªì©lÀɮײ{¦³¤@°ÝÃD¥X²{



Àɮ׳¡¤À C Äæ¤á¦W­ì³]¦³®æ¦¡¤Æ±ø¥ó­«ÂЬۦP¤á¦Wªº¸ê®Æ·|¦³¦â©³+¬õ¦â¦r«¬¤§°Ï§O
¥t D Äæ±b¸¹¦P¼Ë³]¦³®æ¦¡¤Æ±ø¥ó­«ÂЬۦP±b¸¹ªº¸ê®Æ·|¦³¦â©³+¬õ¦â¦r«¬¤§°Ï§O(­«­n¤§°Ñ¦Ò...¬O§_¦³­«½Æ¼Æ¾Ú§PÂ_§R°£¨Ì¾Ú)
¦]µ§¼Æ¸ê®Æ¼W¦h  ³y¦¨¨ç¼Æ COUNTIF Åã¥Ü¯S§OºC, ¸ê®Æµ§¼Æ¼W¥[¤@¦h, ·|¶°é°é¥dÀɤ§µ~ªp!

¬O§_¯à¥H  VBA µ{¦¡³B²z¥[§Ö³t«×
°w¹ï C¡BD ¨âÄæ¿é¤J®É¯à¦³¦Û°Ê§e²{¦p¤W(¦â©³+¬õ¦â¦r«¬¤§°Ï§O)...ªí¥Ü¦³­«½Æ¤§¤á¦W©Î±b¸¹¼Æ¾Ú

0722.rar (48.57 KB)

TOP

¦^´_  cypd

¤£¦n·N«ä¦U¦ì¥ý¶i...
°w¹ïªì©lÀɮײ{¦³¤@°ÝÃD¥X²{



Àɮ׳¡¤À C Äæ¤á¦W­ì³]¦³®æ¦¡¤Æ±ø ...
cypd µoªí©ó 2022-7-22 17:00


³]©w®æ¦¡¤Æ-->­«½Æ­È¡A³o¼ËÀ³¸Ó¥i¥H§a?

1.JPG (153.57 KB)

1.JPG

TOP

        ÀR«ä¦Û¦b : ºÉ¦h¤Ö¥»¥÷¡A´N±o¦h¤Ö¥»¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD