EXCL1903_201978020_김원우_129720_assignsubmission_file_EXCL1903_수식_201978020.xlsm
<p>[점수(100점 만점)] : 80</p><p>[상세점수] : <br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[과제(배점:100점)] : 80<br/></p><p>[문제] : <b>과제, J4:J13, <font color=red>[틀림]등수 구하기 틀림</font></b><br/><pre>[정답] : 	1	=RANK.EQ(H4,$H$4:$H$13)
	<font color=red>4	=RANK.EQ(H5,$H$4:$H$13)</font>
	<font color=red>3	=RANK.EQ(H6,$H$4:$H$13)</font>
	<font color=red>9	=RANK.EQ(H7,$H$4:$H$13)</font>
	<font color=red>7	=RANK.EQ(H8,$H$4:$H$13)</font>
	<font color=red>10	=RANK.EQ(H9,$H$4:$H$13)</font>
	<font color=red>6	=RANK.EQ(H10,$H$4:$H$13)</font>
	<font color=red>5	=RANK.EQ(H11,$H$4:$H$13)</font>
	<font color=red>8	=RANK.EQ(H12,$H$4:$H$13)</font>
	<font color=red>2	=RANK.EQ(H13,$H$4:$H$13)</font>
</pre><br/><pre>[학생] : 	1	=RANK(H4,H4:H13)
	3	=RANK(H5,H5:H14)
	2	=RANK(H6,H6:H15)
	6	=RANK(H7,H7:H16)
	4	=RANK(H8,H8:H17)
	5	=RANK(H9,H9:H18)
	3	=RANK(H10,H10:H19)
	2	=RANK(H11,H11:H20)
	2	=RANK(H12,H12:H21)
	1	=RANK(H13,H13:H22)
</pre><br/></p>