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

¦p¦ó§ì¨úa1:7¤§¶¡ªº²Ä1­Ó¼Æ­È

¦p¦ó§ì¨úa1:7¤§¶¡ªº²Ä1­Ó¼Æ­È

¥»©«³Ì«á¥Ñ lucky12345 ©ó 2011-2-26 14:44 ½s¿è

a1=w
a2=n
a3=8
a4=6
a5=k
a6=3
a7=2
§Ú­n§ì¨úa1:a7¤§¶¡  ¥Ñ¤W¦Ó¤U ªº²Ä¤@­Óɬ¥ýªº¼Æ­È  §Ú¤W­zªº»Ý¨D¬Ob1=8  ¦pªGa1§ïÅܬ°(5)¼Æ­È
«hb1­n=5
¥ýÁÂÁ¤j®a«ü¾É
¥Ø«e¤p¾Ç¥Í´Á«Ý¥L¤é¶i°ê¤¤

¦^´_ 1# lucky12345


    °}¦C¤½¦¡
{=INDEX(A1:A7,MIN(IF(ISNUMBER(A1:A7),ROW(A1:A7),"")),)}
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

ÁÂÁª©¥Dªº¦^À³
·í§Ú¤U©Ô¨ìb3®É.......
b3À³¸Ó¬O8¤~¹ï.......¤£ª¾¬°¦ó=k
ÁÙ¦³¤½¦¡¤£¥Î °}¦C ¬O§_¥i¦æ  ÁÂÁ±z
¥Ø«e¤p¾Ç¥Í´Á«Ý¥L¤é¶i°ê¤¤

TOP

¦^´_ 3# lucky12345


    §Aªº¥Ø¼Ð­È¥u¬O­nA1:A7ªº²Ä¤@­Ó¼Æ­È¡A¬°¦óÁÙ­n¤U©Ô¤½¦¡?
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_  lucky12345


    §Aªº¥Ø¼Ð­È¥u¬O­nA1:A7ªº²Ä¤@­Ó¼Æ­È¡A¬°¦óÁÙ­n¤U©Ô¤½¦¡?
Hsieh µoªí©ó 2011-2-26 16:18



    §Ú¦³a1:a1000
²Î­pªº»Ý­n........¨Da1:a7
¦³®É·|¨Da11:A17....ªº­È....¦¡¼Ë«Ü¦h
©Ò¥H¦³¤U©Ôªº¥²­n
ÁÂÁª©¤j ±z¦A¦¸ªº«ü¾É
¥Ø«e¤p¾Ç¥Í´Á«Ý¥L¤é¶i°ê¤¤

TOP

¦^´_ 5# lucky12345


    ¤U©Ô¤½¦¡³Ì­«­n¬O¦Ò¼{¤U©Ô«á¦C¦ìÅܤÆ
§A­n§â¤U©Ô«á³W«h»¡©ú²M·¡
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

«D±`ÁÂÁª©¤j¼ö¤ßÀ°¦£
­è­è±q§Oªººô¯¸ ª¦¤å§ä¨ì¤@­Ó ´ú¸Õ ok     «Ý¤@·|¦A¨Ó¬ã¨s¤½¦¡
=INDEX(A1:A7,MATCH(1,ISNUMBER(A1:A7)*1,0)).....................°}¦C¤½¦¡
***½Ð°Ý³o¤@©w­n¥Î°}¦C¤½¦¡¶Ü¡H
¥Ø«e¤p¾Ç¥Í´Á«Ý¥L¤é¶i°ê¤¤

TOP

¦^´_ 7# lucky12345


    ³o¼Ë¼gªk¤@©w¬O°}¦C¤½¦¡¿é¤J¤~¦æ
­n¥H´¶³q¤½¦¡¿é¤J¡A¥i±NISNUMBER(A1:A7)*1³¡¤À¥Î©w¸q¦WºÙ
¦p©w¸q¦WºÙx=ISNUMBER(A1:A7)*1
B1¤½¦¡=INDEX(A1:A7,MATCH(1,x,0))
´N¥i¥H¤@¯ëENTER¿é¤J
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_  lucky12345


    ³o¼Ë¼gªk¤@©w¬O°}¦C¤½¦¡¿é¤J¤~¦æ
­n¥H´¶³q¤½¦¡¿é¤J¡A¥i±NISNUMBER(A1:A7)*1³¡ ...
Hsieh µoªí©ó 2011-2-26 18:08



   ¤S¾Ç¤@©Û .........
ÁÂÁª©¤j
¥Ø«e¤p¾Ç¥Í´Á«Ý¥L¤é¶i°ê¤¤

TOP

¶â§Ú¤]¨Ó¬ã¨s¬Ý¬Ý
DREWCHEN1

TOP

        ÀR«ä¦Û¦b : ­ì½Ì§O¤H´N¬Oµ½«Ý¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD