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

[µo°Ý] ¨ç¼Æ°ÝÃD

¥»©«³Ì«á¥Ñ kaigan89 ©ó 2010-9-19 14:41 ½s¿è

=MAX(A1:A&B1)
¬O¿ùªº¡A½Ð°Ý¿ù¦b¦ó¦]¡H
¤S§ï¬°
=MAX("A1:A"&B1)
µª®×¬O#VALUE! ¤S¬O¬°¤°»ò¡H
OFFSET( )¤º¤Þ¼Æ¤£¥Î¥[¤Þ¸¹
¦ýINDIRECT(¡@¡@¡^¶·¥[¤Þ¸¹¡A¦³¨S¦³¥i¨Ì´`ªº³W«h¡H
½Ð¸Ô²Ó¸Ñ»¡¡A¥H§Q«á¾Ç¡IÁÂÁÂ

TOP

        ÀR«ä¦Û¦b : °µ¦n¨Æ¤£¯à¤Ö§Ú¤@¤H¡A°µÃa¨Æ¤£¯à¦h§Ú¤@¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD