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

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

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

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

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



·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))
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 4# hcm19522

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

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

TOP

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD