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

½Ð°Ý°ª¤â

A1¨ìG1Àx¦s®æ
¤¤¥u¦³¤@®æ¦³¤å¦r
¨ä¥¦³£¬O0
«ç¦bH1Åã¥Ü¥X¸Ó½d³ò¤å¦r£z

ÁÂÁÂ
xu123 µoªí©ó 2013-4-10 12:43



    =LOOKUP(,0/(A1:G1<>0),A1:G1)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_  ML089
½Ð±ÐML089¥ý¶i
©µ¦ù°ÝÃD¡G­YA1¨ìG1Àx¦s®æ¤£¥u¤@®æ¦³¤å¦r®É(«D¤å¦r¬°0)¡A
¨Ì LOOKUP(,0/(A1 ...
p212 µoªí©ó 2013-4-11 09:10



¦pªG¬O§ä³Ì¤@®æ¤å¦r
=LOOKUP(1,0/ISTEXT(A1:G1),A1:G1)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_  ML089
¹ï¤£°_¡I¥i¯à没ªí¥Ü²M·¡¡u­YA1¨ìG1Àx¦s®æ¤£¥u¤@®æ¦³¤å¦r®É(«D¤å¦r¬°0)¡vªº°ÝÃD¡AÅý±z»~ ...
p212 µoªí©ó 2013-4-11 09:38



    EXCEL ªº¤å¦rµ²¦X¯à¤OÁ¡®z¡A©Ò¥Hµ²¦X¼Æ¶q­n©ú½T¤~¯à¼g¤½¦¡¡A¤@¯ë¥Î & ©Î CONCATENATE ±N¦U¬q¬d¸ßµ²¦X°_¨Ó¡A¦p: (§ä²Ä¤@­Ó¤å¦r) & (§ä²Ä¤G­Ó¤å¦r)  
   ¨Ò: =INDEX(A1:G1,SMALL(IF(ISTEXT(A1:G1),COLUMN(A:G),99),1)) & INDEX(A1:G1,SMALL(IF(ISTEXT(A1:G1),COLUMN(A:G),99),2)) ¤TÁä¿é¤J

    ¦pªG­n±N©Ò¦³ªº¤å¦rµ²¦X¡A¤]¥i¥H¥Î =PHONETIC(A1:G1)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¥@¤W¦³¨â¥ó¨Æ¤£¯àµ¥¡G¤@¡B§µ¶¶ ¤G¡B¦æµ½¡C
ªð¦^¦Cªí ¤W¤@¥DÃD