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

[µo°Ý] [®É¶¡¿ï¾Ü°ÝÅé] ·í¨t²Îªº¤é´Á®É¶¡¶W¹L¬Y¤@¤é´Á®É¶¡§Ç¦C¤¤ªº­È®É¡A¿ï¥X¤U¤@­Ó¤é´Á®É¶¡

[µo°Ý] [®É¶¡¿ï¾Ü°ÝÅé] ·í¨t²Îªº¤é´Á®É¶¡¶W¹L¬Y¤@¤é´Á®É¶¡§Ç¦C¤¤ªº­È®É¡A¿ï¥X¤U¤@­Ó¤é´Á®É¶¡

½Ð±Ð¤@¤U«e½ú!  
·í¨t²Îªº¤é´Á®É¶¡(Åܰʪº)¶W¹L¤é´Á®É¶¡§Ç¦C¤¤ªº¬Y¤@­Ó­È®É¡A¿ï¥X¤U¤@­Ó¤é´Á®É¶¡¡A¤½¦¡­n¦p¦ó¼g?
®É¶¡¿ï¾Ü.jpg

®É¶¡¿ï¾Ü.rar (7.26 KB)

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2018-4-29 09:17 ½s¿è

¤@¯ë¤½¦¡:
=INDEX(E:E,-LOOKUP(1,-MATCH(F4,E:E,{1,0})-{1,0}))

°}¦C¤½¦¡(¤TÁä¿é¤J)
=MIN(IF(E9:E99>=F4,E9:E99))

TOP

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


    ÁÂÁ­㴣¤j !     ¥i¥H¥Î¤F!

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD