dream_py的博客

1. 数据——排序 =MAX(D:D) =MATCH(J2,D:D,0) =INDEX(C:D,MATCH(J2,D:D,0),1) 2. 城市和口味做透视表 4. =FIND("麻",C2,1) =FIND("辣",C2,1) 开始——筛选（麻、川） 开始——筛选（辣、川） 5. 把口味、环境、服务都做筛选，然后再把城市复制出来，做城市跟总和的数据透视表 6. 先筛选出上海的，再复制到另一个表格，然后按服务进行降序排列，然后再按类型排列。然后 =IF(B2=B3,E2+1,1) 7. =COUNT(

1. =SUMPRODUCT(R2:R3,S2:S3) 2. =COUNT(S:S) 3. =MAX(S2:S11) =MIN(S2:S11) 4. =RANK(S5,S2:S5) 5. =AVERAGEA(R2:R9) 6. =QUARTILE(R2:R5,0) 7. =STDEV(S2:S8) 8. =INT() =ROUND() 9. =COUNTIFS(R2:R14,">10",T2:T14,"毕业生") =SUMIF(T:T,"=应届毕业生",R:R) ...

1. =FIND("k",P2,1) =LEFT(P2,Q2-1) 选择性粘贴为数值 =FIND("-",P2,1) 选择性粘贴为数值 =RIGHT(P2,R2) 2. =CONCATENATE(S2,"k") =S2&"K" 3. =REPLACE(U2,1,2,"k") 4. =SUBSTITUTE(T2,U2,"") 5. TRIM()

1. =IF(Q2>10,"高","低") =IF(Q2>10,IF(T2="应届毕业生","yes","no"),"低") 2. =ISNUMBER(T2)

1. =VLOOKUP(B2,Sheet1!A:B,2,FALSE) 2. =INDEX(Q2:T11,2,2) =MATCH(6,R2:R12,0)或者=MATCH(R2,R2:R12,0) =INDEX(S2:T7,MATCH(S2,S2:S7,0),1) 3. =ROW() =RIGHT(A1,1) =RIGHT(A2,1) 再做筛选 4. =OFFSET(U2,1,1,1,1)