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

[µo°Ý] «ü©w¦C¤§«e3¦W¦U¼Ð¥ÜÃC¦â¤Î«ü©wÄæ¼Ð¥Ü©³¦âªº»yªk¡C

[µo°Ý] «ü©w¦C¤§«e3¦W¦U¼Ð¥ÜÃC¦â¤Î«ü©wÄæ¼Ð¥Ü©³¦âªº»yªk¡C

¥»©«³Ì«á¥Ñ papaya ©ó 2019-3-24 22:23 ½s¿è

¼Ð¥ÜÃC¦â.rar (8.35 KB)

EX_1.png
2019-3-24 22:15

EX_2.png
2019-3-24 22:15

»Ý¨D_1¡J
A1¡JA&¦³¼Æ¦rªº³Ì«á¤@¦C¼Ð¥Ü²LºñÂÅ©³¦â
G1¡JK&¦³¼Æ¦rªº³Ì«á¤@¦C¼Ð¥Ü²LºñÂÅ©³¦â
Q1¡JU&¦³¼Æ¦rªº³Ì«á¤@¦C¼Ð¥Ü²LºñÂÅ©³¦â
AA1¡JAE&¦³¼Æ¦rªº³Ì«á¤@¦C¼Ð¥Ü²LºñÂÅ©³¦â
AK1¡JAO&¦³¼Æ¦rªº³Ì«á¤@¦C¼Ð¥Ü²LºñÂÅ©³¦â
AU1¡JAX&¦³¼Æ¦rªº³Ì«á¤@¦C¼Ð¥Ü²LºñÂÅ©³¦â

»Ý¨D_2-1¡J
±N­Ë¼Æ²Ä7¦C(§YAÄæ=ªÅªº¦C)ªºB¡JAX~
³Ì¤j¼Æ¼Ð¥Ü²L¯»ÂÅ©³¦â(¥i¦³1­Ó¥H¤W)¡F
²Ä¤G¤j¼Æ¼Ð¥Ü«Gºñ©³¦â(¥i¦³1­Ó¥H¤W)¡F
²Ä¤T¤j¼Æ¼Ð¥Ü²L¾í©³¦â(¥i¦³1­Ó¥H¤W)¡F
³Ì¤p¼Æ¼Ð¥Ü¬õ¦â²ÊÅ骺¦rÅéÃC¦â(¥i¦³1­Ó¥H¤W)¡F
²Ä¤G¤p¼Æ¼Ð¥Ü¯»¬õ¦â²ÊÅ骺¦rÅéÃC¦â(¥i¦³1­Ó¥H¤W)¡F
²Ä¤T¤p¼Æ¼Ð¥Ü²`¬õ¦â²ÊÅ骺¦rÅéÃC¦â(¥i¦³1­Ó¥H¤W)¡F

»Ý¨D_2-2¡J
±N­Ë¼Æ²Ä5¦C(§YAÄæ=¾÷ªº¦C)ªºB¡JAX~
³Ì¤j¼Æ¼Ð¥Ü²L¯»ÂÅ©³¦â(¥i¦³1­Ó¥H¤W)¡F
²Ä¤G¤j¼Æ¼Ð¥Ü«Gºñ©³¦â(¥i¦³1­Ó¥H¤W)¡F
²Ä¤T¤j¼Æ¼Ð¥Ü²L¾í©³¦â(¥i¦³1­Ó¥H¤W)¡F
³Ì¤p¼Æ¼Ð¥Ü¬õ¦â²ÊÅ骺¦rÅéÃC¦â(¥i¦³1­Ó¥H¤W)¡F
²Ä¤G¤p¼Æ¼Ð¥Ü¯»¬õ¦â²ÊÅ骺¦rÅéÃC¦â(¥i¦³1­Ó¥H¤W)¡F
²Ä¤T¤p¼Æ¼Ð¥Ü²`¬õ¦â²ÊÅ骺¦rÅéÃC¦â(¥i¦³1­Ó¥H¤W)¡F

¥H¤W»Ý¨D¡A¸Û½Ð¦U¦ì¤j¤jÀ°¦£©M½ç±Ð!
ÁÂÁ¦U¦ì!

°ÝÃD¤w¸Ñ¨M!ÁÂÁÂ!

TOP

¦^´_ 11# hcm19522
hcm19522¤j¤j:
´ú¸Õ¦¨¥\¤F~±zªº¨ç¼Æ³y¸Ú¯u¬O¶W°ª~²Ä¤@¦¸¨£ÃѨì¯B°Êªº®æ¦¡³]©w¨ç¼Æ¤½¦¡~¥O¤H¨ØªA^^
«D±`·PÁ±zªº¼ö¤ß«ü¾É~·P®¦^^

==================================================================================

"ªÅ"¦CªºB:AXÁٻݭn«e¤T¤pªº¼Ð¥Ü¡A¦]¨ü¨ì2003ª©¥u¯à¿é¤J3­Ó±ø¥óªº­­¨î¡A©Ò¥HÁÙ¬O»Ý­n«e3¤j©M«e3¤pªºVBA»yªk~
¸Û½Ð¦U¦ì¤j¤j¤£§[«ü±Ð!ÁÂÁÂ!

TOP

¦^´_ 10# papaya
½d³ò¨úB2:AX99 ¸Õ¸Õ

®æ¦¡¤Æ «ü©w¦æ²Ä 1 2 3¤j (5487).rar (11.5 KB)

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

TOP

¦^´_ 9# hcm19522
´ú¸ÕÀÉ:
EX 1 & 2.rar (15.11 KB)

¤£ª¾§Úªº¾Þ§@¦³¨S¦³¿ù»~?
®æ¦¡³]©w¤½¦¡¦bB2:AX2~´ú¸Õ¨S¦³¦¨¥\^^"
½Ð«ü¥¿!ÁÂÁ±z!

TOP

¦^´_ 7# papaya


    ¸ê®Æ½d³ò49-->20§ï49
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

https://blog.xuite.net/hcm19522/twblog
¥ý¤F¸Ñ¦¹ÅÞ¿èhttps://blog.xuite.net/hcm19522/twblog/587219554
OFFSET($B$1,MATCH("ªÅ",$A:$A,)-1,,,20)-->¾ã¦æ¸ê®Æ
N(OFFSET($A$1,MATCH("ªÅ",$A:$A,)-1,COLUMN(A1)))-->¸Ó¦æ©¹¥k³v¤@¸ê®Æ
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 6# hcm19522
½Ð°Ý:
("ªÅ"¦æ ³Ì¤j)B77:AX???®æ¦¡¤Æ=(LARGE(OFFSET($B$1,MATCH("ªÅ",$A:$A,)-1,,,20),1)=OFFSET($A$1,MATCH("ªÅ",$A:$A,)-1,COLUMN(A1)))*(ROW(A1)=MATCH("ªÅ",$A:$A,)-1)
  °²³]¬O¦b$B17:$AX17
20¬O¥Nªí¤°»ò·N«ä?ÁÂÁ±z!

TOP

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2019-3-30 16:36 ½s¿è

¦^´_ 5# papaya


    ("ªÅ"¦æ ³Ì¤j)B77:AX???®æ¦¡¤Æ=(LARGE(OFFSET($B$1,MATCH("ªÅ",$A:$A,)-1,,,20),1)=OFFSET($A$1,MATCH("ªÅ",$A:$A,)-1,COLUMN(A1)))*(ROW(A1)=MATCH("ªÅ",$A:$A,)-1)
¦¸¤j «Ý¬ã¨s
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 4# hcm19522
hcm19522¤j¤j:±z¦n!
¨ç¼Æ¸Ñ§Ú¤w·|¸Ñ~http://forum.twbts.com/thread-20731-1-1.html~
¦ý¬O¨C­Ó²Î­pªí·|¦]´Á¼Æªº¼W¥[¦Ó¦C¼Æ¤£©T©w¡A©Ò¥H¨ç¼Æ¸Ñ¤£¾A¥Î¡C

ª¦¤å¦h¤é~¥u¦³¦b"ª¾ÃÑ+"§ä¨ì¤@¬q¾A¥Îªº»yªk¡A¦ý¦]¦~¤ë¹L¤[¡A¨ä½d¨Ò¤wµLªk¤U¸ü¡A©Ò¥HA­Èªº³]©wÁÙ¨S¦³·d²M·¡^^"
³Ì«áÁÙ¬O«D±`·PÁ±zªº¸Ñµª^^

TOP

        ÀR«ä¦Û¦b : ¥Ç¿ù¥XÄb®¬¤ß¡A¤~¯à²M²bµL·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD