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)