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

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

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

¦U¦ì¥ý¶i
§Ú·Q¼g¤@­Ó¹Bºâ¦¡¡A¦ý¤£ª¾¹D«ç»ò¼g¡A½Ð¦U¦ìÀ°­Ó¦£
§Ú¦bA1~A100¦³³\¦hªº­È(¼Æ¦r)¤¤¡A¬D¿ï½d³òA1~A5¤¤³Ì¤jªº­È¡A§Úª¾¹D¨ç¼Æ¬O= MAX(A1:A5)
¥i¬O§Ú·Q¦bB1ªº¦a¤è¥[¤@­Ó¥i¥HÅܼÆ
¨Ò¦p»¡¡AB1 =  5¡A´N·|¿ï¥XA1~A5 ¤¤ªº³Ì¤j­È
¦ý§Ú¥u­n§ó§ïB1ªº­È¡A¹³¬O§ï¦¨10¡A´N·|Åã¥ÜA1~A10ªº³Ì¤j­È
³Ì¤j­ÈÅã¥Ü¦bB2        

¥H¤W´N¬O§Úªº°ÝÃD¡A§Æ±æ¦U¦ì¥ý¶i¥i¥HÀ°§Ú¸Ñµª¡A·PÁÂ!!

¦^´_ 1# shadowming


    =MAX(OFFSET(A1,,,B1,))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

=MAX(INDIRECT("A1:A"&B1))

TOP

=MAX(A1:INDIRECT("a"&B1))
joviwang

TOP

¥»©«³Ì«á¥Ñ 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

¦^´_ 5# kaigan89

¤F¸Ñ¨ç¼Æ­Ó¤Þ¼Æªº«¬ºA¤~¯à¥¿½T¤Þ¥Î
OFFSET(reference,rows,cols,height,width)
reference¬O­Ó°Ñ·Ó¦ì§}¡A¥¦¬O±z¥Î¥H­pºâ¦ì²¾µ²ªGªº°_©l¦ì¸m¡CReference ¥²¶·°Ñ·Ó¨ì¬Û¾F¿ï¨ú½d³òªº¤@­ÓÀx¦s®æ©Î½d³ò¡A©Ò¥H¬OÀx¦s®æ¡C
Rows   ¬O¥Î¥H«ü¥Ü¥ª¤W¨¤Àx¦s®æ­n««ª½ (©¹¤W©Î©¹¤U) ²¾°Êªº¦C¼Æ¡A¬O­Ó¼Æ­È¡C
Cols   ¬O¥Î¥H«ü¥Ü¥ª¤W¨¤Àx¦s®æ­n¤ô¥­ (©¹¥ª©Î©¹¥k) ²¾°ÊªºÄæ¼Æ¡A¬O­Ó¼Æ­È¡C
height   ¬O³]©w¶Ç¦^ªº°Ñ·Ó¦ì§}À³¥]¬AªºÀx¦s®æ°ª«× (Àx¦s®æ½d³òªº¦C¼Æ) ªº¼Æ­È¡C¦¹¤Þ¼Æ¥²¶·¬O¥¿¼Æ¡C
Width   ¬O³]©w¶Ç¦^ªº°Ñ·Ó¦ì§}À³¥]¬AªºÀx¦s®æ¼e«× (Àx¦s®æ½d³òªºÄæ¼Æ) ªº¼Æ­È¡C¦¹¤Þ¼Æ¥²¶·¬O¥¿¼Æ¡C


INDIRECT(ref_text,a1)
ref_text   ¬O­Ó³æ¤@Àx¦s®æªº°Ñ·Ó¦ì§}¡F¦Ó³o­ÓÀx¦s®æ§t¦³¨Ì A1 ®æ¦¡©Î R1C1 ®æ¦¡©Ò«ü©wªº°Ñ·Ó¦ì§}¡B¤@­Ó©w¸q¬°°Ñ·Ó¦ì§}ªº¦WºÙ©Î¬O¤@­Ó©w¸q¬°°Ñ·Ó¦ì§}ªº¦r¦ê¡C
a1   ¬O­ÓÅÞ¿è­È¡F¥Î¥H°Ï§O ref_text ©Ò«ü©wªºÀx¦s®æ°Ñ·Ó¦ì§}¡A¬O¥H­þºØ¤è¦¡ªí¥Üªº¡C

¦b¤½¦¡¤¤³Q""¥]ÂЪº³¡¤Àªí¥Ü¬O¦r¦ê
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¶¢¤HµL¼Ö½ì¡A¦£¤HµL¬O«D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD