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

Àx¦s®æ¿ï¾Ü°ÝÃD

Àx¦s®æ¿ï¾Ü°ÝÃD

[attach]33197[/attach]

°ÝÃD.png
2021-4-13 09:45

Àx¦s®æ¿ï¾Ü°ÝÃD.rar (146.18 KB)

Àx¦s®æ¿ï¾Ü°ÝÃD.rar (146.18 KB)

TOP

¦^´_ 2# ªü¦t­ô

D2 = INDEX($E$2:$G$6,ROW(A1),MATCH($D$1,$E$1:$G$1,))

TOP

¦^´_ 2# ªü¦t­ô


½Ð´ú¸Õ¬Ý¬Ý¡AÁÂÁÂ

TOP

·PÁÂS¤j........

TOP

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2021-4-14 14:09 ½s¿è

¯Â¼Æ¦r=SUMIF(E$1:G$1,D$1,E2:G6)

=HLOOKUP(D$1,E:G,ROW(A2),)

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

TOP

D2 =OFFSET(D2,,MATCH(D$1,E$1:G$1,))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¤£©È¨Æ¦h¡A¥u©È¦h¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD