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

[µo°Ý] §ä¨ì²Ä¤@µ§¸ê®Æ¥X²{¦ì¸m

[µo°Ý] §ä¨ì²Ä¤@µ§¸ê®Æ¥X²{¦ì¸m

Lookup¥i¥H§ä¨ì³Ì«á¤@µ§¸ê®Æ¥X²{¦ì¸m,½Ð°Ý¦³¨S¦³¨ç¼Æ¥i¥H§ä¨ì²Ä¤@µ§¸ê®Æ¥X²{¦ì¸m

§Ú§Æ±æ¥i¥H¦^¶Ç¬O2

¥»©«³Ì«á¥Ñ p212 ©ó 2014-6-20 09:10 ½s¿è

¦^´_ 1# imingho
Àx¦s®æF2¿é¤J°}¦C¤½¦¡
{=SMALL(IF(A2:E2<>"",COLUMN(A2:E2),FALSE),1)}
¨äIF(A2:E2<>"",COLUMN(A2:E2),FALSE)¡A¦b§ä¥XA2:E2½d³ò¤£¬°¡uªÅ®æ¡vªº°}¦C¡A¥H1#¹Ï¨Ò§Y±o{FALSE,2,FALSE,4,FALSE}°}¦C¡C
¦V¤U½Æ»s
½Ð°Ñ¦Ò¡I

TOP

¦^´_ 1# imingho


   
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# p212


    ¥i¥H¤F.ÁÂÁÂ..

TOP

¦^´_ 3# Hsieh

ÁÂÁÂ.§Ú¸Õ¥i¥H.¦ý¦pªG¥X²{ªº¦³¥i¯à¬Oa,b,c,d,¬O§_¥u¯à¥Îp212¤j¤jªº°}¦C¤½¦¡.©Î¬O¥Îmatch©Î¬O¨ä¥L«D°}¦C¤½¦¡¤]¥i¥H°µ¨ì.

TOP

¦^´_ 5# imingho


    3#¤½¦¡´N¥i¥H§ä¨ì¤F§r¡I
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 6# Hsieh


  Hsiehª©¥D±z¦n,
       ±zªºµª®×§Ú¦³¥Î¬O¥i¥Hªº,¦ý¬O°²³]§Úªº²Ä¤@­Ó¥X²{ªº¤£¤@¼Ë¬Od, ¦³¥i¯à¬Oabcd¥ô¦ó¤@ºØ,¦p¤U¹Ï,¬O§_¥u¯à¥Îp212¤j¤jªº°}¦C¤½¦¡.©Î¬O¥Îmatch©Î¬O¨ä¥L«D°}¦C¤½¦¡¤]¥i¥H°µ¨ì.

TOP

¦^´_ 7# imingho


    =INDEX($A$1:$E$1,,MATCH("*",$A$2:$E$2,0))

TOP

¦^´_ 7# imingho


F2 =INDEX(A2:E2,MATCH("*",A2:E2,0))

PS: "*" ¶È¾A¥Î©ó¤å¦r¡A¼Æ¦rµLªk¬d¸ß
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 8# jj369963


    ÁÂÁÂjj369963,¥i¥H¨Ï¥Î.

TOP

        ÀR«ä¦Û¦b : ¦³®É·í«äµL®É­W¡A¦n¤Ñ­n¿n«B¨Ó³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD