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

[µo°Ý] ¤£°÷¿n¤À, ¦ý«Ü·Q°Ý­ÓEXCEL·j´M¤Î½g±Æ°ÝÃD

§A­nªº¤é´Á°ÝÃDÀ³¸Ó¬O®æ¦¡³]©wªº°ÝÃD
±`¥Î-----¼Æ­È
§â³q¥Î®æ¦¡§ï¦¨¤é´Á
§ÚµLªk¤U¸üÀÉ®×À°§A
¥u¯à¬Ý§Aªº¹Ï¤F¸Ñ
µLªk½T»{§A¸Ô²Ó»Ý¨D

TOP

§Aªº¤é´Á°ÝÃD
»Ý­n§â¤é´Á¨ºùتº¤½¦¡§ó§ï
¥h±¼«á­±ªº    &""    ´N¥i¥H¤F



³o¸Ìªº½×¾Â³]©w½T¹ê»Ý­n§ï¶i

TOP

¥»©«³Ì«á¥Ñ ML089 ©ó 2017-1-28 00:22 ½s¿è



¦X¨Ö¦U¦~¤À¸ê®Æ
¨Ï¥Î¶i¶¥¿z¿ï


http://www.FunP.Net/405212

20170127 ¶i¶¥¿z¿ï.rar (18.07 KB)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¬Ý¬ÝÀ°ªº¤W¦£¶Ü

¥»©«³Ì«á¥Ñ ªü¼ä ©ó 2017-2-7 18:51 ½s¿è

¤£°÷¿n¤À ¦ý­Ó¤H¸Õ§@ªº ¬Ý¬ÝÀ°ªº¤W¦£¶Ü¡H

20170127 ¶i¶¥¿z¿ï.rar (24.39 KB)

TOP

¦^´_ 13# ML089


¤£¬O«ÜÀ´ª©¥Dªº·N«ä
¦ý¥X¨Óªº®ÄªGÀ³¸Ó¤£¬O²{¶¥¬q»Ý­nªº
ÁÂÁª©¥D¤j¤j

TOP

¦^´_ 12# naruto018


°Ú¬Oªº
ªº½T¥i¥HÅã¥Ü
¦ý§â [ &"" ] §R°£¤S¤Þ¥Ó¥t¤@°ÝÃD
¨S¦³¸ê®Æªº¦a¤è´NÅã¥Ü 1¤ë0¤é
¬Ý¨ÓÂ÷§¹¬üÁÙ­n¦A§ï¶i

TOP

¦^´_ 17# tata211


    §A¥u­n§âÀx¦s®æ®æ¬O¦Û­q¦¨    m"¤ë"d"¤é";[=0]"";@
´N¥i¥H§â 1¤ë0¤é   µ¹ÁôÂð_¨Ó
  

TOP

¦^´_ 18# naruto018


¤Ó·PÁ§A¤F
¤S§ð§J¤@­Ó°ÝÃD:)

TOP

²×©ó¨ì³Ì«á¤@¨B
§¹¦¨´N¸Ñ²æ¤F:D
³o­Ó¤½¦¡¤¤ªº SHEET ¦WºÙ¯à§_»P¤W¤è¦Û¿ï¬Û¹ïÀ³
¹F¨ì¥i¥H¿ï¾Ü±q¨º­ÓSHEET¨ú¥X¸ê®Æ©O?



{=INDEX('2014¦~'!A:A,SMALL(IF('2014¦~'!$C$2:$E$500=$B$2,ROW(A$2:C$200),4^8),ROW(A1)))}

TOP

¤é´Á{=IFERROR(INDEX('2014¦~'!A:A,SMALL(IF('2014¦~'!$C$2:$E$500=$B$2,ROW(A$2:C$500)),ROW(A1))),"")

TOP

        ÀR«ä¦Û¦b : ¡i¬O§_µo´§¤F¨}¯à¡H¡j¤H¶¡¹Ø©R¦]¬°µu¼È¡A¤~§óÅã±o¬Ã¶Q¡CÃø±o¨Ó¤@½ë¤H¶¡¡AÀ³°Ý¬O§_¬°¤H¶¡µo´§¤F¦Û¤vªº¨}¯à¡A¦Ó¤£­n¤@¨ý¨Dªø¹Ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD