[已解决]A1:AD1单元格“休”字之间的距间

zhanmude

距离.zip (7.98 KB, 下载次数: 25)

2014-5-17 01:05 上传

点击文件名下载附件

最佳答案

月排行榜 / 总排行榜

蝶·舞

2014-5-17 08:38

1. =SUBSTITUTE(SUBSTITUTE(TEXT(MID(SUM(FREQUENCY(COLUMN(A:AD),IF(A1:AD1="休",COLUMN(A:AD)))/10^ROW(INDIRECT("1:"&COUNT(FREQUENCY(COLUMN(A:AD),IF(A1:AD1="休",COLUMN(A:AD))))))),4,9),REPT("-#",9)),"---",),"--",)

复制代码

跳转到最佳答案楼层

baksy

有难度~

tgydslr

1. =TEXT(SUM((SMALL(IF(A1:AD1="休",COLUMN(A:AD)),ROW(INDIRECT("2:"&COUNTIF(A1:AD1,"休"))))-SMALL(IF(A1:AD1="休",COLUMN(A:AD)),ROW(INDIRECT("1:"&COUNTIF(A1:AD1,"休")-1))))*10^(COUNTIF(A1:AD1,"休")-1-ROW(INDIRECT("1:"&COUNTIF(A1:AD1,"休")-1)))),REPT("0!-",COUNTIF(A1:AD1,"休")-2)&0)

复制代码

，三键结束

tgydslr

蝶·舞

1. =SUBSTITUTE(SUBSTITUTE(TEXT(MID(SUM(FREQUENCY(COLUMN(A:AD),IF(A1:AD1="休",COLUMN(A:AD)))/10^ROW(INDIRECT("1:"&COUNT(FREQUENCY(COLUMN(A:AD),IF(A1:AD1="休",COLUMN(A:AD))))))),4,9),REPT("-#",9)),"---",),"--",)

复制代码