excel中如何自动列出某个分数段的学生名字?答:方法1:sheet2,C1:=TEXTJOIN(",",1,IF(Sheet1!$D$3:$D$1000>=LEFT(A2,FIND("分",A2)-1)*1,Sheet1!$A$3:$A$1000,""))编辑状态下同时按下Ctrl+Shift+Enetr,不用下拉 sheet2,C2:=TEXTJOIN(",",1,IF((Sheet1!$D$3:$D$1000>=LEFT(A3,FIND("分",A3)-1)*1)*(Sheet1!$...