¿¹Á¦ ÆÄÀÏ ³»·Á¹Þ±â
ÁÖ¾îÁø °ª¿¡¼ ¹«ÀÛÀ§ ÃßÃâÇÒ ÀÏÀÌ ÀÖ´Ù¸é ¾î¶»°Ô ÇØ¾ß ÇÒ±î?
ÀÓÀÇ ÃßÃ⠽à °í·ÁÇØ¾ß µÉ °Ô ÇÑ ¹ø ÃßÃâµÈ °ªÀÌ Áߺ¹ ÃßÃâµÇ´Â °æ¿ì°¡ ¾ø¾î¾ß ÇÑ´Ù´Â °Í. ¾µ ÀÏÀÌ °ÅÀÇ ¾ø¾î¼ »ý°¢Çغ¸Áö ¾Ê¾Ò´Âµ¥ ½É½ÉÇØ¼ ÇÑ ¹ø ±¸ÇغôÙ. ÷ºÎÇÑ ¼ö½ÄÀº ¹è¿¼ö½ÄÀ̶ó ÀÔ·Â ½Ã 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))

|