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

½Ð°Ý°ª¤â

½Ð°Ý°ª¤â

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

ÁÂÁÂ

¦^´_  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

=PHONETIC(A1:G1)

TOP

¦^´_ 7# ML089
¹ï¤£°_¡I¥i¯à没ªí¥Ü²M·¡¡u­YA1¨ìG1Àx¦s®æ¤£¥u¤@®æ¦³¤å¦r®É(«D¤å¦r¬°0)¡vªº°ÝÃD¡AÅý±z»~¸Ñ¤F¡C
°ÝÃD¬O­YA1Àx¦s®æ¤º®e¬°¡u¥Ò¡v¥BD1Àx¦s®æ¤º®e¬°¡u¤A¡v®É¡A«hH1Àx¦s®æ¦^À³µª®×¬°¡u¥Ò¤A¡v¤§LOOKUP²Õ¦X¨ç¼Æ¦p¦ó­×¥¿¡H

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

¥»©«³Ì«á¥Ñ p212 ©ó 2013-4-11 09:12 ½s¿è

¦^´_ 5# ML089
½Ð±ÐML089¥ý¶i
©µ¦ù°ÝÃD¡G­YA1¨ìG1Àx¦s®æ¤£¥u¤@®æ¦³¤å¦r®É(«D¤å¦r¬°0)¡A
¨Ì LOOKUP(,0/(A1:G1<>0),A1:G1)¤§²Õ¦X¨ç¼Æ¡AÀ³¦p¦ó­×§ï©O¡H
ÁÂÁ¡I

TOP

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

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

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



   
ª©³W 13.µo¨¥¤º®e¤£¥i¨Ï¥Îª`­µ¤å¡C(´ä¿D¦a°ÏªºªB¤Í¡A½Ð¨Ï¥Î´¶³q¸Ü)

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

p212¤j
¤Ó§Q®`¤F
¹ï§Aªº´º¥õ¦³¦p¦¿¤ô·Ê·Ê¤£µ´
ªGµM¬O°ª¤â°ª°ª¤â

TOP

¦^´_ 1# xu123
½Ð¦bH1Àx¦s®æ¿é¤J
=SUBSTITUTE(CONCATENATE(A1,B1,C1,D1,E1,F1,G1),"0","")

TOP

        ÀR«ä¦Û¦b : ­n¥Î¤ß¡A¤£­n¾Þ¤ß¡B·Ð¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD