|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
本帖最后由 wddn 于 2012-10-23 09:38 编辑
要求的几何平均值,最后求和:
=SUM((MATCH(A2:A45,A2:A45,)=ROW(1:44))*10^(MMULT((TRANSPOSE(ROW(1:44))>COUNTIF(A2:A45,">"&A2:A45)+2)*(TRANSPOSE(ROW(1:44))<COUNTIF(A2:A45,">="&A2:A45)-1)*TRANSPOSE(LOG(MOD(SMALL(COUNTIF(A2:A45,">"&A2:A45)/1%+B2:B45,ROW(1:44)),100))),1^B2:B45)/(COUNTIF(A2:A45,A2:A45)-4)))
要求的几何平均值,最后求和(247字符):
=SUM((MATCH(A2:A45,A2:A45,)=ROW(1:44))*10^(MMULT((COLUMN(A:AR)>COUNTIF(A2:A45,">"&A2:A45)+2)*(COLUMN(A:AR)<COUNTIF(A2:A45,">="&A2:A45)-1)*LOG(MOD(SMALL(COUNTIF(A2:A45,">"&A2:A45)/1%+B2:B45,COLUMN(A:AR)),100)),1^B2:B45)/(COUNTIF(A2:A45,A2:A45)-4)))
要求的几何平均值,最后求和(236字符):
=SUM(10^(MMULT((COLUMN(A:AR)>COUNTIF(A2:A45,">"&A2:A45)+2)*(COLUMN(A:AR)<COUNTIF(A2:A45,">="&A2:A45)-1)*LOG(MOD(SMALL(COUNTIF(A2:A45,">"&A2:A45)/1%+B2:B45,COLUMN(A:AR)),100)),1^B2:B45)/(COUNTIF(A2:A45,A2:A45)-4))/COUNTIF(A2:A45,A2:A45))
要求的几何平均值,最后求和并保留两位小数(268):
=ROUND(SUM(EXP(MMULT((TRANSPOSE(ROW(2:45))>COUNTIF(A2:A45,">"&A2:A45)+3)*(TRANSPOSE(ROW(2:45))<COUNTIF(A2:A45,">="&A2:A45))*MOD(SMALL(COUNTIF(A2:A45,">"&A2:A45)/1%+LN(B2:B45),TRANSPOSE(ROW(2:45)-1)),100),1^B2:B45)/(COUNTIF(A2:A45,A2:A45)-4))/COUNTIF(A2:A45,A2:A45)),2)
要求的几何平均值,最后求和并保留两位小数(244):
=ROUND(SUM(EXP(MMULT((COLUMN(A:AR)>COUNTIF(A2:A45,">"&A2:A45)+2)*(COLUMN(A:AR)<COUNTIF(A2:A45,">="&A2:A45)-1)*MOD(SMALL(COUNTIF(A2:A45,">"&A2:A45)/1%+LN(B2:B45),COLUMN(A:AR)),100),1^B2:B45)/(COUNTIF(A2:A45,A2:A45)-4))/COUNTIF(A2:A45,A2:A45)),2)
|
本帖子中包含更多资源
您需要 登录 才可以下载或查看,没有账号?免费注册
x
评分
-
2
查看全部评分
-
|