HOME > »ç¿ëÀÚ Á¦°ø ÀÚ·á > Åë°è·Î ¼¼»óº¸±â

'¹«Áö°³Å¸°í'´ÔÀÇ Åë°è°­ÁÂ

Åë°è·Î ¼¼»óº¸±â | ¹«ÀÛÀ§ = ÀÓÀÇ = ·£´ý ÃßÃâ

- Author : ¹«Áö°³Å¸°í

- Released : 2013-11-18

- Read : 2,377 ȸ


¿¹Á¦ ÆÄÀÏ ³»·Á¹Þ±â


ÁÖ¾îÁø °ª¿¡¼­ ¹«ÀÛÀ§ ÃßÃâÇÒ ÀÏÀÌ ÀÖ´Ù¸é ¾î¶»°Ô ÇØ¾ß ÇÒ±î?

ÀÓÀÇ ÃßÃ⠽à °í·ÁÇØ¾ß µÉ °Ô ÇÑ ¹ø ÃßÃâµÈ °ªÀÌ Áߺ¹ ÃßÃâµÇ´Â °æ¿ì°¡ ¾ø¾î¾ß ÇÑ´Ù´Â °Í. ¾µ ÀÏÀÌ °ÅÀÇ ¾ø¾î¼­ »ý°¢Çغ¸Áö ¾Ê¾Ò´Âµ¥ ½É½ÉÇØ¼­ ÇÑ ¹ø ±¸ÇغôÙ. ÷ºÎÇÑ ¼ö½ÄÀº ¹è¿­¼ö½ÄÀ̶ó ÀÔ·Â ½Ã Ctrl + Shift + Enter¸¦ µ¿½Ã¿¡ ´­·¯¾ß ÇÑ´Ù.

1. ÁÖ¾îÁø °ª¿¡¼­ ¹«ÀÛÀ§·Î ÃßÃâÇÏ´Â °æ¿ì: B2 ¼¿(ÀÓÀÇÃßÃâ)

=SMALL(IF(1-COUNTIF(B$1:B1,$A$2:$A$22),$A$2:$A$22),ROUNDUP(RAND()*SUM(1-COUNTIF(B$1:B1,$A$2:$A$22)),0))

2. ƯÁ¤ ±¸°£ ³»¿¡ °ª¿¡¼­ ¹«ÀÛÀ§·Î ÃßÃâÇÏ´Â °æ¿ì: C2 ¼¿(±¸°£Á¶°Ç ÀÓÀÇ ÃßÃâ)

=SMALL(IF(($A$2:$A$22>=-3)*($A$2:$A$22<=3)*(1-COUNTIF(C$1:C1,$A$2:$A$22)),$A$2:$A$22),ROUNDUP(RAND()*SUM(($A$2:$A$22>=-3)*($A$2:$A$22<=3)*(1-COUNTIF(C$1:C1,$A$2:$A$22))),0))


Previous

Next

Copyright ¨Ï Since 2013 ¾ÆÀÌ¿¢¼¿·¯ ´åÄÄ. All rights reserved.

ÀÌ ÆäÀÌÁöÀÇ ÀúÀÛ±ÇÀº ÄÁÅÙÃ÷ Á¦°øÀÚ¿¡°Ô ÀÖ½À´Ï´Ù.

º» °­ÁÂÀÇ ³»¿ëÀº ÇÊÀÚ °³ÀÎÀÇ °ßÇØÀ̸ç, ¾ÆÀÌ¿¢¼¿·¯ ´åÄÄÀÇ °ø½Ä °ßÇØ¿Í ÀÏÄ¡ÇÏÁö ¾ÊÀ» ¼öµµ ÀÖ½À´Ï´Ù.