浙江龙网

  1. 首页 > 生活百科 > >

excel换算得分的50种方法2020开心玩

电脑知识

序号作者字符数公式01wshcw51=LOOKUP(LEFT(A3),{"A","B","C","D";7,4,1,0})+LEN(A3)02wshcw55=VLOOKUP(LEFT(A3),{"A",7;"B",4;"C",1;"D",0},2,)+LEN(A3)03wshcw46=MAX(1,SUMIF(C$3:C$12,A3&"*",B$3)/3+LEN(A3)-2)04wshcw40=SEARCH(LEFT(A3),"DC00B00A",1)+LEN(A3)-105wshcw56=INDEX(B$3:B$12,SEARCH(LEFT(A3),"00A00B00CD"))+LEN(A3)-106wshcw52=INDEX(B$3:B$12,MATCH(LEFT(A3),C$3:C$12,))+LEN(A3)-107wshcw37=10-MATCH(LEFT(A3),C$3:C$12,)+LEN(A3)08wshcw30=MAX(202-3*CODE(A3)+LEN(A3),1)09wshcw34=AVERAGE(IF(C$3:C$12=A3,B$3:B$12))10wshcw63=VLOOKUP(LEFT(A3),CHOOSE({1,2},C$3:C$12,B$3:B$12),2,)+LEN(A3)-111wshcw59=VLOOKUP(LEFT(A3),IF({1,0},C$3:C$12,B$3:B$12),2,)+LEN(A3)-112wshcw45=LOOKUP(A3,LEFT(C$3:C$12),B$3:B$12)+LEN(A3)-113wshcw54=INDEX(B$3:B$12,FIND(LEFT(A3),"12A34B56CD"))+LEN(A3)-114wshcw48=INDEX(B$3:B$12,MATCH(A3,C$3:C$12,))-(LEN(A3)=2)15wshcw35=11-MATCH(A3,C$3:C$12,)-(LEN(A3)=2)16wshcw51=LOOKUP(1,0/(LEFT(A3)=C$3:C$12),B$3:B$12)+LEN(A3)-117wshcw54=MATCH(A3&"*",MID("DC00B00A",ROW($1:$8),1),)+LEN(A3)-118wshcw48=MAX(MATCH(A3,{"D","C","B","A"},)*3-5+LEN(A3),1)19wshcw41=MAX(FIND(LEFT(A3),"DCBA")*3-5+LEN(A3),1)20wshcw42=MOD(-MATCH(A3,C$3:C$12,),10)+(LEN(A3)<>2)21compass53=LOOKUP(LEFT(A3),{"A","B","C","D"},{7,4,1,0})+LEN(A3)22compass36=FIND(LEFT(A3),"DC34B67A")+LEN(A3)-123zz515135341=LOOKUP(2,1/(FIND(A3,C$3:C$12)),B$3:B$12)24lzw59035=SUMPRODUCT((C$3:C$12=A3)*B$3:B$12)25mxqchina44=SUMIF(C$3:C$12,SUBSTITUTE(A3,"*","~*"),B$3)26bosco_yip37=LOOKUP(,-FIND(A3,C$3:C$12),B$3:B$12)27bosco_yip32=MID(7410,CODE(A3)-64,1)+LEN(A3)28bosco_yip28=SUM((C$3:C$12=A3)*B$3:B$12)29bosco_yip39=OFFSET(B$2,MATCH(1,--(C$3:C$12=A3),),)30bosco_yip42=INDEX(B$3:B$12,MATCH(1,--(C$3:C$12=A3),))31bosco_yip66=HLOOKUP(LEFT(A3),TRANSPOSE({"A",7;"B",4;"C",1;"D",0}),2,)+LEN(A3)32bosco_yip54=CHOOSE(MATCH(2,1/(C$3:C$12=A3)),10,9,8,7,6,5,4,3,2,1)33bosco_yip44=INDIRECT("B"&(MATCH(1,--(C$3:C$12=A3),)+2))34bosco_yip28=MAX((C$3:C$12=A3)*B$3:B$12)35bosco_yip29=MAXA((C$3:C$12=A3)*B$3:B$12)36bosco_yip30=-MIN(-(C$3:C$12=A3)*B$3:B$12)37bosco_yip31=-MINA(-(C$3:C$12=A3)*B$3:B$12)38bosco_yip32=LARGE((C$3:C$12=A3)*B$3:B$12,1)39bosco_yip34=SMALL(IF(C$3:C$12=A3,B$3:B$12),1)40bosco_yip36=PRODUCT(IF((C$3:C$12=A3),B$3:B$12))41bosco_yip41=MMULT(--TRANSPOSE(C$3:C$12=A3),B$3:B$12)42bosco_yip64=INDIRECT(ADDRESS(MATCH(SUBSTITUTE(A3,"*","~*"),C$3:C$12,)+2,2))43bosco_yip63=INDIRECT("R"&MATCH(SUBSTITUTE(A3,"*","~*"),C$3:C$12,)+2&"C2",)44bosco_yip57=INDEX(B$3:B$12,MATCH(SUBSTITUTE(A3,"*","~*"),C$3:C$12,))45bosco_yip65=OFFSET(A:A,,1,) INDEX(B:B,MATCH(1,INDEX(--(A3=C$3:C$12),,),)+2,)46x.f.zhao37=SUMIF(C$3:C$12,LEFT(A3),B$4)+LEN(A3)47wxyqxxz200736=CHOOSE(69-CODE(A3),0,1,4,7)+LEN(A3)48qinqh_yl31=ABS((67-CODE(A3))*3+1+LEN(A3))49qinqh_yl45=11-MATCH(SUBSTITUTE(A3,"*","~*"),C$3:C$12,0)50qinqh_yl65=VLOOKUP(SUBSTITUTE(A3,"*","~*"),IF({1,0},C$3:C$12,B$3:B$12),2,0)

    推荐阅读


    上一篇：Excel-中-Text-函数应用技巧集锦2020攻略资讯

    下一篇：如何利用Excel求解方程？Excel的特别功能您需要了解的