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

[µo°Ý] °ÊºA¨â¼h¤U©Ô¦¡¿ï³æ

¥»©«³Ì«á¥Ñ p212 ©ó 2014-8-8 11:47 ½s¿è

¦^´_ 1# bridetobe
1¡B©w¸q¦WºÙ¡u¼t°Ó¦W¡v¤§°Ñ·Ó¨ì«ØÄ³­×§ï¦¨
=OFFSET(«~¦W²M³æ!$A$1,,,,COUNTA(«~¦W²M³æ!$1:$1))
2¡B¥t·s©w¸q¦WºÙ¡uRng¡v¡A°Ñ·Ó¨ì¿é¤J
=«~¦W²M³æ!$A$1:$Z$26
3¡B·Æ¹«ÂI«ö¡u±ÄÁÊ©ú²Ó¡v¤u§@ªí¤§Àx¦s®æF2¡AÅçÃÒ¸ê®Æ¨Ó·½¿é¤J
=OFFSET(«~¦W²M³æ!$A$2,,MATCH($E2,¼t°Ó¦W,)-1,COUNTA(INDEX(Rng,0,MATCH($E2,¼t°Ó¦W,)))-1)
¥HÀx¦s®æF2¬°¼ÒªO¦V¤U½Æ»s§Y¥i
4¡B¦WºÙºÞ²z­û¤¤¡A°£©w¸q¦WºÙ¡u¼t°Ó¦W¡v»P¡uRng¡v¥~¡A¨ä¾l«ØÄ³¥i§R°£¡C
½Ð°Ñ¦Ò¡I

TOP

        ÀR«ä¦Û¦b : °µ¸Ó°µªº¨Æ¬O´¼¼z¡A°µ¤£¸Ó°µªº¨Æ¬O·Mè¡C
ªð¦^¦Cªí ¤W¤@¥DÃD