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

[µo°Ý] VBA ·j´M¸ê®Æ¦C¹ïÀ³ªº³Ì¤j­È©Î³Ì¤p­È

¥»©«³Ì«á¥Ñ owen06 ©ó 2014-11-28 10:47 ½s¿è

¦^´_ 1# junkwei


    §ä´M²Å¦X±ø¥óªº³Ì¤j­È¡G
    ¦bF2¿é¤J=MAX(($A$2:$A$16=E2)*$C$2:$C$16)¡A¦¹¬°°}¦C¤½¦¡¡A¿é¤J§¹¦¨«á­n«öCTRL+SHIFT+ENTER¡A
    ¦A§â¤½¦¡©¹¤U©Ô§Y¥i¡C
   
    §ä´M²Å¦X±ø¥óªº³Ì¤p­È¡G
    ¦bG2¿é¤J=MIN(IF($A$2:$A$16=E2,$C$2:$C$16,FALSE))¡A¦¹¬°°}¦C¤½¦¡¡A¿é¤J§¹¦¨«á­n«öCTRL+SHIFT+ENTER¡A
    ¦A§â¤½¦¡©¹¤U©Ô§Y¥i¡C

TOP

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD