EXCL1906_201922042_전현성_134484_assignsubmission_file_201922042전현성.xlsm

[점수(100점 만점)] : 95

[상세점수] :
        [과제(배점:100점)] : 95

[문제] : 과제, L4:L33, [틀림]등수 계산이 틀렸습니다.

[정답] : 	1	=RANK.EQ(J4,$J$4:$J$33)
	4	=RANK.EQ(J5,$J$4:$J$33)
	6	=RANK.EQ(J6,$J$4:$J$33)
	19	=RANK.EQ(J7,$J$4:$J$33)
	28	=RANK.EQ(J8,$J$4:$J$33)
	11	=RANK.EQ(J9,$J$4:$J$33)
	26	=RANK.EQ(J10,$J$4:$J$33)
	14	=RANK.EQ(J11,$J$4:$J$33)
	22	=RANK.EQ(J12,$J$4:$J$33)
	8	=RANK.EQ(J13,$J$4:$J$33)
	14	=RANK.EQ(J14,$J$4:$J$33)
	2	=RANK.EQ(J15,$J$4:$J$33)
	3	=RANK.EQ(J16,$J$4:$J$33)
	26	=RANK.EQ(J17,$J$4:$J$33)
	16	=RANK.EQ(J18,$J$4:$J$33)
	20	=RANK.EQ(J19,$J$4:$J$33)
	9	=RANK.EQ(J20,$J$4:$J$33)
	21	=RANK.EQ(J21,$J$4:$J$33)
	24	=RANK.EQ(J22,$J$4:$J$33)
	11	=RANK.EQ(J23,$J$4:$J$33)
	17	=RANK.EQ(J24,$J$4:$J$33)
	10	=RANK.EQ(J25,$J$4:$J$33)
	18	=RANK.EQ(J26,$J$4:$J$33)
	7	=RANK.EQ(J27,$J$4:$J$33)
	30	=RANK.EQ(J28,$J$4:$J$33)
	13	=RANK.EQ(J29,$J$4:$J$33)
	5	=RANK.EQ(J30,$J$4:$J$33)
	29	=RANK.EQ(J31,$J$4:$J$33)
	23	=RANK.EQ(J32,$J$4:$J$33)
	25	=RANK.EQ(J33,$J$4:$J$33)

[학생] : 	1	=RANK(J4,J4:J33,0)
	3	=RANK(J5,J5:J34,0)
	4	=RANK(J6,J6:J35,0)
	16	=RANK(J7,J7:J36,0)
	24	=RANK(J8,J8:J37,0)
	8	=RANK(J9,J9:J38,0)
	21	=RANK(J10,J10:J39,0)
	10	=RANK(J11,J11:J40,0)
	16	=RANK(J12,J12:J41,0)
	5	=RANK(J13,J13:J42,0)
	9	=RANK(J14,J14:J43,0)
	1	=RANK(J15,J15:J44,0)
	1	=RANK(J16,J16:J45,0)
	15	=RANK(J17,J17:J46,0)
	7	=RANK(J18,J18:J47,0)
	9	=RANK(J19,J19:J48,0)
	3	=RANK(J20,J20:J49,0)
	8	=RANK(J21,J21:J50,0)
	9	=RANK(J22,J22:J51,0)
	4	=RANK(J23,J23:J52,0)
	5	=RANK(J24,J24:J53,0)
	3	=RANK(J25,J25:J54,0)
	4	=RANK(J26,J26:J55,0)
	2	=RANK(J27,J27:J56,0)
	6	=RANK(J28,J28:J57,0)
	2	=RANK(J29,J29:J58,0)
	1	=RANK(J30,J30:J59,0)
	3	=RANK(J31,J31:J60,0)
	1	=RANK(J32,J32:J61,0)
	1	=RANK(J33,J33:J62,0)