¹Ù·Î°¡±â

Áñ°Üã±â 

[ÄÄÇ»ÅÍ/ÀÎÅͳÝ]

¿¢¼¿ ±ÛÀÚ ÃßÃâ ÇÔ¼ö °í¼ö´Ô µµ¿ÍÁÖ¼¼¿ä

rank ½ÅºñÇÑÀο¬ 2020-01-21 (È­) 00:09 Á¶È¸ : 806
ÇÔ¼ö¸¦ ½á¼­ ±ÛÀÚ¸¦ ÃßÃâÇÏ°í ½Í½À´Ï´Ù. ¸ÅÅ©·Î´Â ½ÇÇàÀÌ ¾ÈµÇ¼­¿ä

¿¹Á¦ , ¾ÕÀÚ¸® °íÁ¤ 7,8ÀÚ¸®, Áß°£°ªµé °¡º¯ÀÌÁö¸¸ ³¡¿¡ ±ÛÀÚ°¡ /E , /MÀ¸·Î ³¡³³´Ï´Ù. 

1AB1234[ab123K/E,HF123K/M,SWUN-T12345K#1/E]
11AB1234[ab1234#1 /E, ab1234#1 /M, ,SWUN-T123456#1/E,SWUN- T123456K #1/M]
11AB1234[ab12345#1 /E, ab12345#1 /M ,SWUN-T123456#1/E,SWUN-T1234567K#1/M]


¿©±â¼­ ¾ÕÀÚ¸®´Â 7ÀÚ¸®³ª 8ÀÚ¸® °íÁ¤ [ 11AB1234  ÀÌ°Ç °¡Áö°í ¿À±â°¡ ½±´õ¶ó±¸¿ä]
=LEFT(a1,FIND("[",a1)-1) ÀÌ·¸°Ô ÇÏ¸é °¡Á® ¿ÍÁö´õ¶ó±¸¿ä 

Áß°£ °ªµéÀº /M À̳ª /E¶ó´Â°É  Á¦¿ÜÇÏ°í ÃßÃâÇÏ°í ½Í½À´Ï´Ù. ¾î¶»°Ô ÇؾßÇÒ±î¿ä?

¿¹¸¦ µé¸é ÀÌ·±½ÄÀ¸·Î ÃßÃâÇÏ°í ½ÍÀºµ¥ mid¶û right ÇÔ¼ö¶û lenÇÔ¼ö leftÇÔ¼ö¸¦ ¿©·¯¹ø ÁßøÇصµ ½±Áö °¡ ¾Ê³×¿ä 

11AB1234[ab12345#1 /E, ab12345#1 /M ,SWUN-T123456#1/E,SWUN-T1234567K#1/M]
11AB1234 ab12345#1(À̰͵µ ½±´õ¶ó±¸¿ä) =MID(a1,FIND("[",a1)+1,FIND("/",a1)-FIND("[",",a9)-1)

ab12345#1[ ÀÌ°Ô ¾î·Æ½À´Ï´Ù.]
SWUN-T123456#1[À̰͵µ ¾î·Æ½À´Ï´Ù.]
SWUN-T1234567K#1[À̰͵µ ¾î·Æ½À´Ï´Ù. ]

¹æ¹ý ¾Æ½Ã´Â ºÐ ¾È°è½Å°¡¿ä?


¿äûÀÚ°¡ ÀÚ½ÅÀÇ 1111Æ÷ÀÎÆ®¸¦ °É¾ú½À´Ï´Ù. ´äº¯ÀÌ Ã¤ÅõǸé 556Æ÷ÀÎÆ®¸¦ µå¸³´Ï´Ù.
´ñ±Û 6°³ ´ñ±Û¾²±â
rankºÎ¾ý¾² 2020-01-21 (È­) 00:17
substitute ´ø°¡...
/mÀ» ºóÄ­À¸·Î ±³Ã¼(»èÁ¦)ÇÒ ¼öÀÖ´Â ÇÔ¼ö ÀÔ´Ï´Ù
     
       
rank½ÅºñÇÑÀο¬ ±Û¾´ÀÌ 2020-01-21 (È­) 00:33
ºóÄ­À¸·Î ¸¸µé°Å³ª ,¸¸ ³²°Ô ¸¸µé¾ú´Âµ¥ ±× ÀÌÈĸ¦ ÁøÇàÀ» ¸øÇÏ°í ÀÖ½À´Ï´Ù.  µÎ¹ø° ÄÞ¸¶³ª °ø¹éÀ» ¾î¶»°Ô  ã¾Æ¼­ Àû¿ëÇؾßÇÒÁö ¸ð¸£°Ú½À´Ï´Ù.
rank³ªµµÀ͸í 2020-01-21 (È­) 00:43
 1.xlsx (10.1KB), Down : 9, 2020-01-21 00:43:57

ÆíÇÑ°Å °ñ¶ó¾²¼¼¿ä.
     
       
rank½ÅºñÇÑÀο¬ ±Û¾´ÀÌ 2020-01-21 (È­) 00:50
¿Í Á¤¸» ¸¶¹ýÀÌ³×¿ä ¸¶¹ý °¨»çÇÕ´Ï´Ù. °í¹Î Çѹ濡 ÇØ°áÀÔ´Ï´Ù. Ȥ½Ã SWUNÀÌ ¾Æ´Ï¶ó ´Ù¸¥ ¹®ÀÚ¿­·Î ·£´ýÇÏ°Ô ½ÃÀÛÇÑ´Ù¸é ±×°Ç Ã£±â Èûµé°ÚÁÒ....?
rank³ªµµÀ͸í 2020-01-21 (È­) 12:07
ÄÞ¸¶¸¦ ã´Â ¹æ¹ýÀ¸·Î ÇÏ½Ã¸é µÇ°ÚÁÒ?
     
       
rank½ÅºñÇÑÀο¬ ±Û¾´ÀÌ 2020-01-21 (È­) 22:54
¹Ù»Ú½Å¿ÍÁß¿¡ ½Ã°£³»Áּż­ Á¤¸» °¨»çµå¸³´Ï´Ù. ^^

¹øÈ£ Á¦¸ñ ±Û¾´ÀÌ »óÅ Æ÷ÀÎÆ® ³¯Â¥ Á¶È¸
[°øÁö]  ¡Ø Áö½ÄiN °Ô½ÃÆÇ ÀÌ¿ë¾È³» rankeToLAND
0 03-28
[°øÁö]  ¡Ø Å䷻Ʈ»çÀÌÆ®Áú¹®,ÀúÀÛ±Ç ÀÚ·á¿äû ±ÝÁö rankeToLAND
0 08-25
[Áß°íÂ÷»ó´ã]  Æ縮¼¼À̵å 3.8 Ķ¸® À͸í
129533 [TV/¿µ»ó]  À¯Æ©ºê¿¡¼­ Á¶°¢ Á¶°¢ÀÖ´Â TV ¿µ»ó ¿Ïü´Â ¾î¶»°Ô (2) rankÀÏ»ó»ýÈ°¸ðÇè
369 17:23 92
129532 [À½¾Ç]  Çª¹Ù 2000 »ç¿ë¹ý (2) rank¿Àºü³ª¾ß
5000 04:33 98
129531 [°ÔÀÓ]  ¿¾³¯ ¿Â¶óÀΰÔÀÓ Á¦¸ñ ã½À´Ï´Ù. (1) rankºù±Ûºù±×¸£
1000 03:59 75
129530 [Ãë¹Ì/»ýÈ°]  ¸ðµç ¸ñÀç Á¶°ÇÀÌ ÁÁÀ¸¸é 50³â ÀÌ»ó °¡³ª¿ä ??? rankÀÏ»ó»ýÈ°¸ðÇè
369 00:13 102
129529 [±³À°/Çй®]  ºÎóöÇÐ °øºÎ ¹æ¹ý? (2) rankÅ»ê°õ
200 03-28 77
129528 [Ãë¹Ì/»ýÈ°]  ¹è ³ó»ç¸¦ ½ÃÀÛÇÏ·Á°í ÇÕ´Ï´Ù. °£·«ÇÑ ¼³¸íºÎŹµå·Á¿ä (1) rankÀÏ»ó»ýÈ°¸ðÇè
369 03-28 87
129527 [ÄÄÇ»ÅÍ/ÀÎÅͳÝ]  pc±¸¸Å ÈÄ ¸ð´ÏÅÍ ½ÅÈ£¾øÀ½.. ¾î¶»Çϳª¿ä?.txt (14) rank¿©Àڿ;ÆÀ̴³öÁà
5000 03-27 130
129526 [°ÔÀÓ]  ¸®´ÏÁö ¼­¹ö±¸ÃàÀ̶û ¼­¹öÆÑ ¾î¶»°Ô ±¸ÃàÇÏ°í ±¸Çϳª¿ä [Á¤º¸±Û] (1) rankÄ¿ÇÇÇÑÀÜÀÇ¿©À¯
3000 03-27 135
129525 [ÄÄÇ»ÅÍ/ÀÎÅͳÝ]  ÄÄÇ»ÅÍ ·¥ xmp Àß ¾Æ½Ã´ÂºÐ °è½Å°¡¿ä?.txt (8) rank¿©Àڿ;ÆÀ̴³öÁà
5000 03-27 116
129524 [Ãë¹Ì/»ýÈ°]  ³» BIZ Áöµµ¾îÇÿ¡ ¶ß°Ô ¸¸µé·Á¸é ¾î¶»°Ô Çϳª¿ä ??? rankÀÏ»ó»ýÈ°¸ðÇè
369 03-26 79
129523 [¼îÇÎ]  ½ºÅ¸¹÷½º ¹ÙÄÚµå Áú¹®Á» µå·Á¿ä (2) rankenrilj
1000 03-26 90
129522 [°Ç°­/ÀÇÇÐ]  ½ºÅ×·ÎÀ̵å ÁÖ»ç ¹®ÀÇ ÀÔ´Ï´Ù.. (1) rank·°Å°³Ñ¹ö¼¼ºì
300 03-26 89
129521 [±âŸ]  ¿ÀÇǽºÅÚ¿¡ »ó°¡ ·»Æ®Ä«ÀÔÁ¡ÇÏ¿© ÁÖ°ÅÁö¿ªÀ» ħ¹üÇÏ¿© ÁÖÂ÷ÇÏ´Â °æ¿ì (1) rank°í¼¼±¸
500 03-26 167
129520 [Ãë¹Ì/»ýÈ°]  ÀÌ°Å ¹«½¼ ¹ú·¹ÁÒ (3) rankº¹Á¶¸®
200 03-25 173
129519 [ÄÄÇ»ÅÍ/ÀÎÅͳÝ]  ¹æ¾È¿¡¼­ ¿ÍÀÌÆÄÀÌ°¡ ³Ê¹« ´À·Á¿ä (3) À̹ÌÁö rank±×¸®¿î±×³¯
300 03-25 234
129518 [ÄÄÇ»ÅÍ/ÀÎÅͳÝ]  À¯Æ©ºê ¸ô¶§ È­¸éÀÌ ¸¹ÀÌ ±ôºýÀÔ´Ï´Ù (3) rank°¡ÀÏ
200 03-25 156
129517 [¼îÇÎ]  ÀÌ°¡¹æ ¾îµð¼­ ÆÄ´ÂÁö Ȥ½Ã ã¾ÆÁÖ½Ç ´É·ÂÀںР°è½Ç±î¿ä (2) À̹ÌÁö rank»ß»Ç»ß
1000 03-24 206
129516 [ÄÄÇ»ÅÍ/ÀÎÅͳÝ]  ¸ÞÀκ¸µå Á¡ÆÛ¼±ÀÌ º´·Ä·Î µþ ¼ö ÀÖ°Ô ³ª¿Â°Ô ÀÖÀ»±î¿ä? À̹ÌÁö rank°õ³ª¶óÅÊ
2000 03-24 134
129515 [¼îÇÎ]  ½ãÅ©¸² ¹«½¼ Á¦Ç°Àϱî¿ä? (1) À̹ÌÁö rank±¤°í¹ÌħÀÌ
2000 03-23 106
129514 [ÄÄÇ»ÅÍ/ÀÎÅͳÝ]  ÀÌ Æ÷ÅäÇÁ¸°ÅÍ Á¦Ç°¸í ¾Æ½Ã´Â ºÐ? (1) À̹ÌÁö rank±¤°í¹ÌħÀÌ
2000 03-23 126
129513 [°Ç°­/ÀÇÇÐ]  ¼¿ÇÁ ¼Òº¯°Ë»ç.. ÇÇ°Ë»ç.. (2) rankÀÏ»ó»ýÈ°¸ðÇè
369 03-23 126
129512 [ÄÄÇ»ÅÍ/ÀÎÅͳÝ]  ¿¢¼¿ ¿¬¼ÓµÈ ÇÏÀÌÆÛ¸µÅ© ¼öÁ¤ (7) rank´Þºû³ëÀ»
300 03-22 154
129511 [±âŸ]  ¾²·¹±â ºÐ¸®¼ö°Å Àß ¾Æ½Ã´ÂºÐ °è½Å°¡¿ä?.txt (2) rank¿©Àڿ;ÆÀ̴³öÁà
1500 03-21 144
129510 [ÄÄÇ»ÅÍ/ÀÎÅͳÝ]  ¤· ºí·Î±×¸¦ ÇÏ°í ½ÍÀº Ã浿ÀÌ ÀϾ½À´Ï´Ù. ¤· À̹ÌÁö rankÀÏ»ó»ýÈ°¸ðÇè
369 03-20 106
129509 [ÄÄÇ»ÅÍ/ÀÎÅͳÝ]  ¸ð´ÏÅÍ¾Ï ÃßõÇØÁÖ¼¼¿ä. (6) rank¶×»Ç
1000 03-20 143
129508 [°ÔÀÓ]  À¥°ÔÀÓ(Browser game) ÃßõÇØ ÁÖ¼¼¿ä (1) rankWangch
1600 03-20 133
129507 [±âŸ]  »ï±¹Áö º¸·Á°í Çϴµ¥¿ä (4) rankÈ¿¼ºÇϾÌ
5000 03-20 144
129506 [±âŸ]  ÃµÇýÇâ °õÆÎÀÌ Àΰ¡¿ä? (3) À̹ÌÁö rankmabury
200 03-19 224
129505 [ÄÄÇ»ÅÍ/ÀÎÅͳÝ]  8 Ãþ °Ç¹° 7Ãþ â¹®¿¡¼­ Èí¿¬½Ã ¿¬±â È帧¿¡ ´ëÇÑ ¹®ÀÇ (4) À̹ÌÁö rankÀÏ»ó»ýÈ°¸ðÇè
369 03-19 153
129504 [ÀüÀÚ±â±â]  Àΰ­¿ë Å×ºí¸´ Ãßõ ºÎŹ µå¸³´Ï´Ù. [ÀÚÇÊ] (3) À̹ÌÁö rankKhaos
5000 03-19 133
129503 [±âŸ]  ¼Ò±Ô¸ð ¾ÆÆÄÆ® Àå±â¼ö¼±Ãæ´ã±Ý »ç¿ë°èȹ¼­ ÀÛ¼º¹ý (4) À̹ÌÁö rank¹Ù¸£´Ù
400 03-18 161
129502 [Ãë¹Ì/»ýÈ°]  ¤· ÃæÀü½Ä Àüµ¿°ø±¸ ¸íĪ ¹®ÀÇ (4) À̹ÌÁö rankÀÏ»ó»ýÈ°¸ðÇè
369 03-18 159
129501 [Ãë¹Ì/»ýÈ°]  ¿Â¼ö ÄÚÀϳ­¹æ ½ÃÀÛµÈ ½Ã±â ¾Æ½Ã´ÂºÐ - ±¹³» - ÇØ¿Ü - (2) À̹ÌÁö rankÀÏ»ó»ýÈ°¸ðÇè
369 03-18 155
129500 [°æÁ¦/ÀçÅ×Å©]  ¸»¼Ò±âÁرǸ® Àü/ÈÄ·Î ÀüÀÔ/È®Á¤ÀÏÀÚ°¡ ºÐ¸®µÈ °æ¿ì¿¡ ´ëÇØ Áú¹® µå¸³´Ï´Ù. rank¼ö¸·ÀÌ
500 03-18 77
129499 [¼îÇÎ]  ½ÅÇÑ ÄíÆÎüũīµå..½ÇÀû (2) rank±³¹Ì³×ÀÌÅÍ
5000 03-18 205
129498 [ÄÄÇ»ÅÍ/ÀÎÅͳÝ]  mp4 ÆÄÀÏ ¿¡ ÀÖ´Â ¹è°æ À½¾Ç¸¸ Á¦°ÅÇÑ ÆÄÀÏ·Î ÆíÁý ÇÒ¼ö ÀÖ´Â ¹«·á »çÀÌÆ®³ª ÇÁ·Î±×·¥ ¾Ë°í ½Í½À´Ï´Ù. (530MB) (2) À̹ÌÁö rank¤±µñ¤±µð°í¤Ã
1000 03-18 130
129497 [±³À°/Çй®]  ºÒõ³ë - ºÐ³ë¸¦ ¿Å±âÁö ¾Ê´Â´Ù - ¿µ¾î·Î ¸¸µé¾îÁÖ¼¼¿ä (1) rankÀÏ»ó»ýÈ°¸ðÇè
586 03-18 81
129496 [ÄÄÇ»ÅÍ/ÀÎÅͳÝ]  Æù °ÔÀÓ ¼Óµµ°¡ ´À·ÁÁö´ÂÀÌÀ¯°¡ ¹»±î¿ä? (4) rank¾ÆÀÓ´Ð
1000 03-17 115
129495 [ÀüÀÚ±â±â]  È¤½Ã RCA ÄÉÀÌºí¿¡ ´ëÇؼ­ ¾Æ½Ã´Â ºÐ ÀÖÀ¸½Å°¡¿ä? (4) À̹ÌÁö rankÀ̶ó·Î±×¿À
200 03-17 149
129494 [°ÔÀÓ]  mvp ¾ß±¸ °ÔÀÓ [ÀÚÇÊ] rankºñ¹ÐÈ­¿ø
200 03-17 117

Áú¹®°ú´äº¯ ¿ù°£ ÃÖ´ÙäÅà ¿ì¼ö´äº¯È¸¿ø

  • rank±×±îÀ̲¨¹¹¶ó°í äÅô亯¼ö (11)
  • rank¿©Àڿ;ÆÀ̴³öÁà äÅô亯¼ö (8)
  • rankÀÌÈ­¿¡¿ù´ãÇÏ°í äÅô亯¼ö (3)
  • rankdasari äÅô亯¼ö (3)
  • rank´É±ÛÀÌ3 äÅô亯¼ö (2)
  • rank¹ÐÁö¸¶ äÅô亯¼ö (2)
  • rankÁöÇÏ¶ó°¡ Ã¤Åô亯¼ö (1)
  • rankWangch äÅô亯¼ö (1)
  • rankºñÁöÀÌ Ã¤Åô亯¼ö (1)
     1  2  3  4  5  6  7  8  9  10  ´ÙÀ½
    ¸Ç À§·Î
    ¸Ç ¾Æ·¡·Î

    °øÀ¯Çϱâ

    ÀÌÅä·£µå ·Î°í

    °èÁ¤ ã±â ȸ¿ø°¡ÀÔ
    ¼Ò¼È·Î±×ÀÎ