先上结果图:![1709260472288975.png image.png](/upload/wenda/20240301/1709260472288975.png) 过程图:![1709260496527810.png image.png](/upload/wenda/20240301/1709260496527810.png) C11公式: indexofarray(A3:A8, let(a,A11, if(a<=20,1, if(a<=40,2, if(a<=60,3, if(a<=100,4, if(a<=130,5,6))))) )) D11公式: IF(ISNULL(B11),NULL,EVAL( CONCATENATE(let(a,B11, if(a<=2,'B', if(a<=4,'C','D')) ),2+let(a,A11, if(a<=20,1, if(a<=40,2, if(a<=60,3, if(a<=100,4, if(a<=130,5,6))))) ))))
RANK(D11,D11:D14,0) F11公式:count(greparray(e11:e14,item==E11))/count(e11:e14) 最后的最后:↓ 交叉引用.zip
|