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

[µo°Ý] ½Ð°Ý­n²Å¦X¨â±ø¥ó¦^¶Ç¸ê®Æ,¨ç¼Æ­n¦p¦ó¼g?

[µo°Ý] ½Ð°Ý­n²Å¦X¨â±ø¥ó¦^¶Ç¸ê®Æ,¨ç¼Æ­n¦p¦ó¼g?

½Ð°Ý¦U¦ì¤j¤j
¦pªG­n²Å¦X¨â±ø¥ó¦^¶Ç¸ê®Æ,¨ç¼Æ­n¦p¦ó¼g?
2021-05-02_194649.jpg
2021-5-2 19:50

²Å¦X¨â±ø¥ó¦^¶Ç¸ê®Æ0502.rar (17.33 KB)

¦^´_ 1# marklos

½Ð¸Õ¬Ý¬Ý¡AÁÂÁ¡C

²Å¦X¨â±ø¥ó¦^¶Ç¸ê®Æ0503.zip (17.41 KB)

TOP

https://blog.xuite.net/hcm19522/twblog/589751100

C3:E3 ¤U©Ô {=OFFSET(BOB!$A$1,SMALL(IF((BOB!$A$1:$A$14=LOOKUP("¼_",$A$3:$A3))*(LEFT(BOB!$B$1:$B$14,2)="AL"),ROW($1:$14),99),ROW()-LOOKUP(1,0/($A$2:$A3<>""),ROW($2:3))+1)-1,CHOOSE(COLUMN(A1),2,6,4))&""
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

·PÁ¨â¦ì¤j¤jªºÀ°¦£,°ÝÃD¤w¸Ñ¨M
ÁÂÁÂ

TOP

¥»©«³Ì«á¥Ñ zz5151353 ©ó 2021-9-7 22:19 ½s¿è

¤u§@ªí¦WºÙ¬° sum

½ÐÂIÀ»·Æ¹«¥ªÁä¿ï¾Ü½d³ò°Ï°ìÀx¦s®æ C3:E3 ¡F ½Ð§â¤U­±ªº¤½¦¡¸m©ñ¦b¤½¦¡Ä椤¡AµM«á¬O°}¦C¤½¦¡
  1. =INDEX(BOB!$A:$G,SMALL(IF(BOB!$A$1:$A$30=LOOKUP("Z",$A$3:$A3),ROW($1:$30),9999),ROW()-LOOKUP(2,1/($A$3:$A3<>""),ROW($A$3:$A3))+1),{3,7,5})
½Æ»s¥N½X
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ­n¥Î¤ß¡A¤£­n¾Þ¤ß¡B·Ð¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD