CHOOSE, RANK ÇÔ¼ö Áßø»ç¿ë
=CHOOSE(index_num, value1, [value2]¡¦)=RANK(number, ref, [order])
µÑ´Ù ¾Õ¿¡¼ ¹è¿îÇÔ¼öÀä CHOOSEÇÔ¼ö´Â INDEX¹øÈ£ °ª¿¡ µû¶ó µÚ¿¡ ³ª¿µÈ °ªÀ» ºÒ·¯ ¿Ã¼ö ÀÖ´Â ÇÔ¼öÀÔ´Ï´Ù.
RANKÇÔ¼ö´Â ¹üÀ§¾È¿¡ µé¾î ÀÖ´Â ¼ýÀÚÀÇ ¼øÀ§¸¦ ¸Å±æ¼ö ÀÖ´Â ÇÔ¼öÀÔ´Ï´Ù.
CHOOSE ÇÔ¼ö ÀÚ¼¼ÇѼ³¸í ¹Ù·Î°¡±â <==
RANK ÇÔ¼ö ÀÚ¼¼ÇѼ³¸í ¹Ù·Î°¡±â <==
¡Ø ¾Æ·¡ Á÷¿øº° ±³»çº° º¸³Ê½º Áö±ÞÇ¥¿¡¼ Æò°¡Á¡¼ö·Î ±³»çº° ¼øÀ§¸¦ ±¸ÇÏ¿© º¸³Ê½ºÁö±Þ¾×¶õ¿¡
1À§´Â 300¸¸¿ø, 2À§´Â 200¸¸¿ø 3À§´Â 100¸¸¿øÀ» ÀÔ·ÂÇÏ´Â ¿¹Á¦¸¦ Ç®¾îº¸¼¼¿ä.
¸ÕÀú RANKÇÔ¼ö¸¦ ÀÌ¿ëÇؼ Æò°¡Á¡¼öÀÇ ¼øÀ§¸¦ ±¸ÇÏ¿©,
CHOOSEÇÔ¼ö¸¦ ÀÌ¿ëÇØ ¼øÀ§º° º¸³Ê½º ±Ý¾×À» ÀÔ·ÂÇϵµ·Ï ¼ö½ÄÀ» ÀÛ¼ºÇÏ¸é µË´Ï´Ù.
ÇÔ¼ö¸¦ ÁßøÇÏ¿© »ç¿ëÇÒ¶§´Â ÇÔ¼ö ÇϳªÇϳª Ç®¾î¼ ÀÛ¼ºÇϸé ÁÁÀºµ¥¿ä,
RANKÇÔ¼ö¸¦ ÀÌ¿ëÇÏ¿© D4:D6±îÁöÀÇ ±îÁöÀÇ ¼øÀ§¸¦ ±¸ÇÏ´Â ¼ö½ÄÀ» ±¸ÇØ¾ß Çϴµ¥
¸ÕÀú ºó¼¿¿¡ =RANK(D4, $D$4:$D$6) ¶ó°í ÀÔ·ÂÇØÁÝ´Ï´Ù. D4¼¿ Áï 550ÀÇ ¼øÀ§´Â 2À§¶ó´Â °ÍÀ» ¾Ë¼ö ÀÖ½À´Ï´Ù.
À̶§ Àý´ëÂüÁ¶¸¦ ÇÏ´Â ÀÌÀ¯´Â ÇÔ¼ö º¹»ç½Ã D4:D6±îÁö ¹üÀ§°¡ º¯ÇÏÁö ¾Ê°Ô Çϱâ À§ÇÔÀÔ´Ï´Ù.
±×´ÙÀ½ CHOOSEÇÔ¼ö¸¦ ÀÌ¿ëÇؼ CHOOSE ÇÔ¼öÀÇ INDEX ÀμöÀÚ¸®¿¡ ¾Õ¼±¸ÇÑ RANK ¼ö½ÄÀ» ³Ö¾îÁÖ°í
¼ø¹ø¿¡ µû¶ó¼ ±Ý¾×À» 300¸¸¿ø, 200¸¸¿ø, 100¸¸¿ø¼øÀ¸·Î ³Ö¾îÁÖ¸é ¾Æ·¡¿Í °°Àº ¼ö½ÄÀ» ±¸ÇÒ ¼ö ÀÖ½À´Ï´Ù.
=CHOOSE(RANK(D4, $D$4:$D$6), 3000000, 2000000, 1000000)
ÀÌ ¼ö½ÄÀ» E4¼¿¿¡ ÀÔ·ÂÇÑµÚ E4:E6±îÁö ¹üÀ§¸¦ ÁöÁ¤ÇÏ¿© µå·¡±× ÇÏ¸é ¾Æ·¡¿Í °°Àº °á°ú°ªÀ» ¾òÀ» ¼ö ÀÖ½À´Ï´Ù.
CHOOSE, RANK ÁßøÇÔ¼ö
CHOOSE, RANK ÇÔ¼ö Áßø»ç¿ë
=CHOOSE(index_num, value1, [value2]¡¦)
=RANK(number, ref, [order])
µÑ´Ù ¾Õ¿¡¼ ¹è¿îÇÔ¼öÀä CHOOSEÇÔ¼ö´Â INDEX¹øÈ£ °ª¿¡ µû¶ó µÚ¿¡ ³ª¿µÈ °ªÀ» ºÒ·¯ ¿Ã¼ö ÀÖ´Â ÇÔ¼öÀÔ´Ï´Ù.
RANKÇÔ¼ö´Â ¹üÀ§¾È¿¡ µé¾î ÀÖ´Â ¼ýÀÚÀÇ ¼øÀ§¸¦ ¸Å±æ¼ö ÀÖ´Â ÇÔ¼öÀÔ´Ï´Ù.
CHOOSE ÇÔ¼ö ÀÚ¼¼ÇѼ³¸í ¹Ù·Î°¡±â <==
RANK ÇÔ¼ö ÀÚ¼¼ÇѼ³¸í ¹Ù·Î°¡±â <==
¡Ø ¾Æ·¡ Á÷¿øº° ±³»çº° º¸³Ê½º Áö±ÞÇ¥¿¡¼ Æò°¡Á¡¼ö·Î ±³»çº° ¼øÀ§¸¦ ±¸ÇÏ¿© º¸³Ê½ºÁö±Þ¾×¶õ¿¡
1À§´Â 300¸¸¿ø, 2À§´Â 200¸¸¿ø 3À§´Â 100¸¸¿øÀ» ÀÔ·ÂÇÏ´Â ¿¹Á¦¸¦ Ç®¾îº¸¼¼¿ä.
¸ÕÀú RANKÇÔ¼ö¸¦ ÀÌ¿ëÇؼ Æò°¡Á¡¼öÀÇ ¼øÀ§¸¦ ±¸ÇÏ¿©,
CHOOSEÇÔ¼ö¸¦ ÀÌ¿ëÇØ ¼øÀ§º° º¸³Ê½º ±Ý¾×À» ÀÔ·ÂÇϵµ·Ï ¼ö½ÄÀ» ÀÛ¼ºÇÏ¸é µË´Ï´Ù.
ÇÔ¼ö¸¦ ÁßøÇÏ¿© »ç¿ëÇÒ¶§´Â ÇÔ¼ö ÇϳªÇϳª Ç®¾î¼ ÀÛ¼ºÇϸé ÁÁÀºµ¥¿ä,
RANKÇÔ¼ö¸¦ ÀÌ¿ëÇÏ¿© D4:D6±îÁöÀÇ ±îÁöÀÇ ¼øÀ§¸¦ ±¸ÇÏ´Â ¼ö½ÄÀ» ±¸ÇØ¾ß Çϴµ¥
¸ÕÀú ºó¼¿¿¡ =RANK(D4, $D$4:$D$6) ¶ó°í ÀÔ·ÂÇØÁÝ´Ï´Ù. D4¼¿ Áï 550ÀÇ ¼øÀ§´Â 2À§¶ó´Â °ÍÀ» ¾Ë¼ö ÀÖ½À´Ï´Ù.
À̶§ Àý´ëÂüÁ¶¸¦ ÇÏ´Â ÀÌÀ¯´Â ÇÔ¼ö º¹»ç½Ã D4:D6±îÁö ¹üÀ§°¡ º¯ÇÏÁö ¾Ê°Ô Çϱâ À§ÇÔÀÔ´Ï´Ù.
±×´ÙÀ½ CHOOSEÇÔ¼ö¸¦ ÀÌ¿ëÇؼ CHOOSE ÇÔ¼öÀÇ INDEX ÀμöÀÚ¸®¿¡ ¾Õ¼±¸ÇÑ RANK ¼ö½ÄÀ» ³Ö¾îÁÖ°í
¼ø¹ø¿¡ µû¶ó¼ ±Ý¾×À» 300¸¸¿ø, 200¸¸¿ø, 100¸¸¿ø¼øÀ¸·Î ³Ö¾îÁÖ¸é ¾Æ·¡¿Í °°Àº ¼ö½ÄÀ» ±¸ÇÒ ¼ö ÀÖ½À´Ï´Ù.
=CHOOSE(RANK(D4, $D$4:$D$6), 3000000, 2000000, 1000000)
ÀÌ ¼ö½ÄÀ» E4¼¿¿¡ ÀÔ·ÂÇÑµÚ E4:E6±îÁö ¹üÀ§¸¦ ÁöÁ¤ÇÏ¿© µå·¡±× ÇÏ¸é ¾Æ·¡¿Í °°Àº °á°ú°ªÀ» ¾òÀ» ¼ö ÀÖ½À´Ï´Ù.