ªð¦^¦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 (148.96 KB)

®É¶¡¿ï¾Ü.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 : ª¾ÃÑ­n¥Î¤ßÅé·|¡A¤~¯àÅܦ¨¦Û¤vªº´¼¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD