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

¦p¦ó­pºâ¯x°}¬Y¤@Ä檺³Ì°ª»ù¡H

¦p¦ó­pºâ¯x°}¬Y¤@Ä檺³Ì°ª»ù¡H

¤w«Ø¥ß¤@­ÓªÑ²¼¨C¤é¥æ©ö¯x°} stockdata()
¸Ì­±¦³5­ÓÄæ¦ì¡A¤À§O¬O¡G¤é´Á¡A¶}½L»ù¡A³Ì°ª»ù¡A³Ì§C»ù¡A¦¬½L»ù
¦C¼Æ¦@¦³10¦C¡A¥Nªí10¤éªº¥æ©öª¬ªp¡C

½Ð°Ý¡A§Ú­n¦p¦óÂ^¨ú10¤é¥H¨Óªº³Ì°ª¶}½L»ù¡H

½Ð¦U¦ì«e½ú«üÂI
ÁÂÁ¤F

¨ú³Ì¤j­È¤£¬O¥ÎMAX(½d³ò)´N¥i¥H¶Ü

TOP

¨ú³Ì¤j­È¤£¬O¥ÎMAX(½d³ò)´N¥i¥H¶Ü
koo µoªí©ó 2015-12-27 19:41


¦pªG¯x°}¤¤¥u³æ¯Âªº«Ø¥ß10¤Ñªº³Ì°ª»ù¡A¬O¥i¥H¥Î¤U­±³o¤@­Ó»yªk
³Ì°ª»ù= Application.Max(stockdata())

¦ý¦pªG¦b¯x°}¥]§t¦h­Ó¸ê®Æªºª¬ªp¤U¡A§Ú­n¦p¦ó¥u¿ï¾Ü¨ä¤¤ªº¤@Äæ¥X¨Ó¹Bºâ¡H
ÁٽЫe½ú«ü¾É

Thank you.

TOP

¦^´_ 3# finjerry
³Ì¦nªº¤èªk´N¬O¤W¶Ç§AªºÀɮסA
¦p¦¹¤j®a¤~±o¥H©úÁA§AÀɮ׸ԲӧG¸m¤º®e¡C

TOP

http://blog.xuite.net/hcm19522/twblog/368681404

TOP

¦^´_ 1# finjerry

'¤Q¤é¤¤¶}½Lªº³Ì°ª»ù
stockdata = [A2:E11] '¤é´Á¡A¶}½L»ù¡A³Ì°ª»ù¡A³Ì§C»ù¡A¦¬½L»ù
maxH = Application.Max(Application.Index(stockdata, , 2))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : §g¤l¥ß«í§Ó¡A¤p¤H«í¥ß§Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD