</p><span style="FONT-SIZE: 16pt; FONT-FAMILY: 仿宋_GB2312; mso-hansi-font-family: 宋体; mso-bidi-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-font-kerning: 1.0pt;"><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Tahoma;">1</span><span style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: 宋体; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma; mso-ascii-font-family: Tahoma;">、美国式排名:</span><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Tahoma;">=RANK</span><span style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: 宋体; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma; mso-ascii-font-family: Tahoma;">(</span><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Tahoma;">G5,G$5:G$15)<br/></span><span style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: 宋体; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma; mso-ascii-font-family: Tahoma;">中国式排名:</span><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Tahoma;">=SUMPRODUCT((G$5:G$15>=G5)*(1/COUNTIF(G$5:G$15,G$5:G$15)))<br/>2</span><span style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: 宋体; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma; mso-ascii-font-family: Tahoma;">、</span><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Tahoma;">=SUMIF(G5:G15,">=300")/COUNTIF(G5:G15,">=300")<br/>3</span><span style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: 宋体; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma; mso-ascii-font-family: Tahoma;">、</span><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Tahoma;">=SUMPRODUCT((C5:C15>80)*(E5:E15>80))<br/>4</span><span style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: 宋体; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma; mso-ascii-font-family: Tahoma;">、</span><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Tahoma;">{=AVERAGE(IF((C5:C15>80)*(E5:E15>80),G5:G15,""))}</span></p></span>[/hide][em17][em17][em17]
[此贴子已经被一剑惊心于2010-2-2 19:43:38编辑过] |