- 博客(2)
- 收藏
- 关注
原创 查找文科第40名学生的总成绩
P$2:$P$3000,0),LEFT(RIGHT(B3,LEN(B3)-FIND("前",B3)),LEN(RIGHT(B3,LEN(B3)-FIND("前",B3)))-1))=LEFT(RIGHT(B3,LEN(B3)-FIND("前",B3)),LEN(RIGHT(B3,LEN(B3)-FIND("前",B3)))-1) 40。G2:G3000,0),40)=RIGHT(B3,LEN(B3)-FIND("前",B3)) 40名。=FIND("前",B3)=FIND("名",B3)
2023-08-03 10:29:50
32
原创 excel COUNTIF 函数 多条件查询 引用单元格
G1:G3000,">=537",总成绩!C1:C3000,"="&CONCAT(RIGHT(A7,2),"班"),总成绩!C1:C3000,"="&CONCAT(RIGHT(A7,2),"班"))G1:G3000,">=537",总成绩!C1:C3000,"=17班",总成绩!C1:C3000,"=17班")C1:C3000,"="&CONCAT(RIGHT(A7,2),"班"))C1:C3000,"="&CONCAT(RIGHT(A7,2),"班"))=CONCAT(RIGHT(A7,2),"班")
2023-08-02 11:29:37
947
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人