|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
求助:TRANSFORMl语句实现各科分数段统计出错
TRANSFORM Count(生物) AS 生物 SELECT 班级 FROM [cj$d1:p800] GROUP BY 班级 PIVOT Switch([生物]>=115 ,"115以上",[生物]>=110 And [生物]<115,"115>X≥110",[生物]>=100 And [生物]<110,"110>X≥100",[生物]>=90 And [生物]<100,"100>X≥90",[生物]>=80 And [生物]<90,"90>X≥80",[生物]>=70 And [生物]<80,"80>X≥70",[生物]>=60 And [生物]<70,"70>X≥60",[生物]>=50 And [生物]<60,"60>X≥50",True,"50以下") In ("115以上",115>X≥110,"110>X≥100","100>X≥90","90>X≥80","80>X≥70","70>X≥60","60>X≥50","50以下")" |
|