|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
王拥军 发表于 2020-1-11 19:55
=OFFSET(INDIRECT(TEXT(SMALL(IF($F$2:$AJ$526=MAX($F$2:$AJ$526),ROW($2:$526)/1%%+COLUMN($F:$AJ)),INT(( ...
帮你修改了下,,不过嵌套超过7层了,必须OFFICE07以上
=OFFSET(INDIRECT(TEXT(SMALL(IF($F$2:$AJ$526=LARGE(IF(FREQUENCY($F$2:$AJ$526,21-ROW($6:$15)),ROW($6:$15)),MATCH(,0/(COLUMN(A1)/4<=MMULT(N(COLUMN($A:$K)<=ROW($1:$11)),FREQUENCY($F$2:$AJ$526,21-ROW($6:$15)))),)),ROW($2:$526)/1%%+COLUMN($F:$AJ)),INT((COLUMN(A1)-1)/4)+1),"r0c0000"),),,,-7,3)&"" |
评分
-
1
查看全部评分
-
|