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

[µo°Ý] ¸ê®ÆÅã¥Ü«ü©wÀx¦s®æ

[µo°Ý] ¸ê®ÆÅã¥Ü«ü©wÀx¦s®æ

½Ð°Ý¦³¨S¦³¤½¦¡¥i¥H±N¸ê®ÆÅã¥Ü«ü©wÀx¦s®æ.·Q­n¶À¦âÅã¥Üªºµ²ªG
¨Ò¦p±NH2,H3,Åã¥Ü¦bI10,J11
          H18,H19,Åã¥Ü¦bI26,J26

Â^¨ú.PNG (16.56 KB)

Â^¨ú.PNG

TEST0607.zip (8.06 KB)

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2022-7-7 11:00 ½s¿è

I10:J10 ¤U©Ô=IF($A10="TOTAL",OFFSET($H$1,LOOKUP(1,0/($G$2:$G9="No :"),ROW($1:1))+COLUMN(A1)-1,),"")

https://blog.xuite.net/hcm19522/twblog/590449930
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

        ÀR«ä¦Û¦b : ¡i¦æµ½­n¤Î®É¡j¦æµ½­n¤Î®É¡A¥\¼w­n«ùÄò¡C¦p¿N¶}¤ô¤@¯ë¡A¥¼¿N¶}¤§«e¤d¸U¤£­n°±º¶¤õ­Ô¡A§_«h­«¨Ó´N¤Ó¶O¨Æ¤F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD