学生成绩表

学生成绩学号姓名性别语文数学英语物理化学平均成绩名次0730201梁宽男85.5095.0096.5070.5081.5085.810730202郝晓楠男77.0080.5095.0094.5075.0084.430730203孙倩女89.0081.0071.5075.0086.5080.640730204王言旭男82.5074.0079.0053.5050.0067.880730205方志和男92.5088.5089.5076.5078.008520730206蔡恒男75.0073.0064.0068.5046.0065.390730207张雯雅女43.0086.5060.5073.0041.0060.8110730208谢逊男62.0069.5094.5076.0065.5073.560730209罗轩然男79.0064.0097.5073.0089.5080.640730210杨浩男70.5084.0074.0069.5057.5071.170730211李韵芹女67.0073.0061.0074.5048.0064.7100730212梁宽男61.7870.3870.3770.7152.5365.15454545‘=RANK’J18,L23‘$J$7:$J$17)0730213郝晓楠男59.6168.9568.7270.3050.4063.59545455#N/A0730214孙倩女57.4467.5167.0769.9048.2662.03636364#N/A0730215王言旭男55.2666.0765.4269.5046.1360.47727273#N/A0730216方志和男53.0964.6463.7769.0944.0058.91818182#N/A0730217蔡恒男50.9263.2062.1268.6941.8757.35909091#N/A0730218张雯雅女48.7561.7660.4768.2839.7455.8#N/A0730219谢逊男46.5760.3358.8267.8837.6054.24090909#N/A0730220罗轩然男44.4058.8957.1767.4735.4752.68181818#N/A0730221杨浩男42.2357.4555.5267.0733.3451.12272727#N/A