ªð¦^¦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

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
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

        ÀR«ä¦Û¦b : ¯à·F¤£·F¡A¤£¦p­W·F¹ê·F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD