本帖最后由 象山海鲜 于 2020-4-9 14:40 编辑
1.
- =T(INDIRECT(TEXT(MOD(INT(DOLLARFR(SMALL(IF(FREQUENCY(ROW(12:48),COUNTIF(A2:C5,">"&TRANSPOSE(A2:C5))+ROW(1:3)*12),ROW(4:16)),ROW())/4,4)*101),50)+20,"r0c0"),))
复制代码 挖几个- =INDEX(T(OFFSET(A2,MOD(ROW(4:16),4),ROW(4:16)/4-1)),SMALL(IF(FREQUENCY(ROW(12:48),COUNTIF(A2:C5,">"&TRANSPOSE(A2:C5))+ROW(1:3)*12),ROW(1:13)),ROW()))
复制代码
2.
- =T(INDIRECT(TEXT(MOD(INT(DOLLARFR(SMALL(IF(FREQUENCY(ROW(1:12),COUNTIF(A2:C5,">="&TRANSPOSE(A2:C5))),ROW(4:16)),ROW())/4,4)*101),50)+20,"r0c0"),))
复制代码 |