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

[µo°Ý] ¦p¦ó±NÅܼƥN¤J¤½¦¡

[µo°Ý] ¦p¦ó±NÅܼƥN¤J¤½¦¡

¥»©«³Ì«á¥Ñ bhsm ©ó 2023-2-10 16:21 ½s¿è

­ì¨Óªº¤½¦¡¬O¡G
¦b¤u§@ªí1ªºB1=MAX(¤u§@ªí2!A5:A68)¡A¦ý·Q­n¦b¤u§@ªí1ªºB4¿é¤J¼Æ¦r¨Ó§ïÅÜA5¡A
¨Ò¦p¦b¤u§@ªí1ªºB4¿é¤J9¡A«hB1=MAX(¤u§@ªí2!A9:A68)¡A
­Y¦b¤u§@ªí1ªºB4¿é¤J50¡A«hB1=MAX(¤u§@ªí2!A50:A68)
½Ð°Ý­n¦p¦ó­×§ï¨ç¼Æ?
¦~ÄÖ¤£¤p,¦ý§Ú«Ü·Q¾Ç

¦^´_ 1# bhsm


    ÁÂÁ«e½úµoªí¦¹¥DÃD
«á¾Ç«Øij¤è®×:
[¤u§@ªí1!B1]¤½¦¡  :   
=IF(B4=9,MAX(¤u§@ªí2!A9:A68),IF(B4=50,MAX(¤u§@ªí2!A50:A68),""))
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

TOP

¥»©«³Ì«á¥Ñ bhsm ©ó 2023-2-10 17:03 ½s¿è

¦^´_ 2# Andy2483
·PÁÂAndy2483¤jªº¦^ÂÐ,À³¸Ó¬O¤p§Ìµü¤£¹F·N,¤p§Ì·Qª¾¹D¦pªG±NB4§ïÅܬ°¥ô¤@¼Æ®É,­n¥Î¤°»ò¨ç¼Æ¨Ó¦Û°Ê§ïÅÜA5¤¤"5"¨º­Ó¼Æ­È
¦~ÄÖ¤£¤p,¦ý§Ú«Ü·Q¾Ç

TOP

=MAX(indirect("'¤u§@ªí2'!A"&b4&":A68"))

TOP

¦^´_ 4# ­ã´£³¡ªL
·PÁ­㴣³¡ªL¤j,´À§Ú¸Ñ¨M³o§xÂZªº°ÝÃD,·P®¦!
¦~ÄÖ¤£¤p,¦ý§Ú«Ü·Q¾Ç

TOP

¥»©«³Ì«á¥Ñ Andy2483 ©ó 2023-2-15 11:07 ½s¿è

¦^´_ 4# ­ã´£³¡ªL


    ÁÂÁ«e½ú
1.indirect():¶Ç¦^¤å¦r¦ê©Ò«ü©wªº°Ñ·Ó
https://support.microsoft.com/zh-tw/office/indirect-%E5%87%BD%E6%95%B8-474b3a3a-8a26-4f44-b491-92b6306fa261

2."'¤u§@ªí2'!A"&b4&":A68" :¨â­Ó³æ¤Þ¸¹¥]§¨ªº¦r¦êµø¬°¤@­Ó¦r¦ê,§_«h¦pªG©¿²¤¦¹¨â­Ó³æ¤Þ¸¹¥B¤u§@ªí¦W¦r¤S¦³ªÅ¥Õ¦r¤¸!·|¥X¿ù,
­n²ßºD¦b ¤u§@ªí¦W¦r «e«á¥[¤J³æ¤Þ¸¹
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

TOP

¦^´_ 6# Andy2483
·PÁÂAndy2483¤jªº´£¿ô,¤p§Ì¤S¦h¾Ç¤F³o­Ó§Þ¥©,ÁÂÁÂ
¦~ÄÖ¤£¤p,¦ý§Ú«Ü·Q¾Ç

TOP

        ÀR«ä¦Û¦b : ¦³´¼¼z¤~¯à¤À¿ëµ½´c¨¸¥¿¡F¦³Á¾µê¤~¯à«Ø¥ß¬üº¡¤H¥Í¡C
ªð¦^¦Cªí ¤W¤@¥DÃD