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

[µo°Ý] ¾î¦¡§ïª½¦¡

[µo°Ý] ¾î¦¡§ïª½¦¡

¥»©«³Ì«á¥Ñ papaya ©ó 2018-4-29 00:50 ½s¿è

´ú¸ÕÀÉ¡J ¾î¦¡§ïª½¦¡.rar (2.57 KB)

¾î¦¡§ïª½¦¡.png
2018-4-29 00:37


·Q±N¾î¦¡ªí¦C§ï¬°ª½¦¡ªí¦C¡C
J2:J8=TRANSPOSE(K1:Q1)ªº°}¦C¤½¦¡°£¥~¡C

½Ð±Ð¡J
J2ªº¤½¦¡­n¦p¦ó½s¼g¡HÁÂÁ¡I

=INDEX(B:H,J$1+1,ROW(A1))

TOP

¥»©«³Ì«á¥Ñ papaya ©ó 2018-4-29 09:11 ½s¿è

¦^´_ 2# ­ã´£³¡ªL
µo°Ý«e¡A¦³¦bºô¸ô·j´M"¾î¦¡§ïª½¦¡"¨ç¼Æ±Ð¾Ç¡J
http://isvincent.pixnet.net/blog/post/45502513-excel-%E6%9F%A5%E8%A1%A8%E5%BE%8C%E6%AC%84%E4%BD%8D%E7%94%B1%E6%A9%AB%E8%BD%89%E7%9B%B4%E9%A1%AF%E7%A4%BA(sumproduct,offset)

¬Ý¤F¦Ñ¥b¤Ñ¡AºN¤£µÛÀYºü^^"

µo°Ý«á¡Aª©¥Dªº¸Ñµª¤½¦¡Â²³æ©öÀ´¡C
¨ü¯q¨}¦h!·P®¦!

TOP

=OFFSET(A$1,J$1,ROW(A1))
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 4# hcm19522

¨S·Q¨ì¥ÎOFFSET¨ç¼Æ¤]¥i¥H¸ÑÃD¡C

¨ü¯q¨}¦h!·P®¦!

TOP

        ÀR«ä¦Û¦b : Ãø¦æ¯à¦æ¡AÃø±Ë¯à±Ë¡AÃø¬°¯à¬°¡A¤~¯àª@µØ¦Û§Úªº¤H®æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD