[字符争霸第五期]求各行各任意数字间最小间距[已开贴]

gxp98765

给老四一个面子 我也凑个热闹吧
=IF(COUNT(A2:G2)=1,MAX(A2:G2),MIN(LARGE(A2:G2,ROW(INDIRECT("$1:$"&COUNT(A2:G2)-1)))-LARGE(A2:G2,ROW(INDIRECT("$2:$"&COUNT(A2:G2))))))
数组

tgydslr

先来一个最菜的，直译152字符

1. =IF(COUNT(A2:G2)=1,A2:G2,MIN(SMALL(IF(A2:G2<>"",A2:G2),ROW(INDIRECT("2:"&COUNT(A2:G2))))-SMALL(IF(A2:G2<>"",A2:G2),ROW(INDIRECT("1:"&COUNT(A2:G2)-1)))))

复制代码

，三键下拉

lasharks

三键下拉，有空再改

1. =MIN(ABS(A2:G2-TRANSPOSE(A2:G2))+((A2:G2="")+(ROW($1:$7)=COLUMN($A:$G)))*100)

复制代码

sgxb123431380

{=SMALL(ABS(LARGE(A2:G2,ROW(INDIRECT("$1:$"&COUNT(A2:G2))))-A2:G2),COUNT(A2:G2)+1)}

戒不掉心中的瘾

=MIN(IFERROR(LARGE(A2:G2,ROW($1:$7))-IFERROR(LARGE(A2:G2,ROW($2:$7)),0),99))

FnG

好久没玩函数了，想不到更好的，71字符：

1. =MIN(IFERROR(LARGE(A2:G2,ROW($1:6))-LARGE(A2:G2,ROW($2:7)),SUM(A2:G2)))

复制代码

xiaoni

不理解什么意思？

vadera

1. =MIN(FREQUENCY(ROW(A:A)-100,A9:G9),SUM(A9:G9))

复制代码

hsl215

虽然公式很长，但结果还是正确的，
=IF(COUNT(A2:G2)=1,MIN(A2:G2),MIN(IF(ISNUMBER(LARGE(A2:G2,COLUMN(A2:G2))-LARGE(A2:G2,COLUMN(B2:G2))),LARGE(A2:G2,COLUMN(A2:G2))-LARGE(A2:G2,COLUMN(B2:G2)),"")))
三键结束
=IF(COUNT(A2:G2)=1,MIN(A2:G2),MIN(LARGE(A2:G2,ROW(INDIRECT("1:"&COUNT(A2:G2)-1)))-LARGE(A2:G2,ROW(INDIRECT("2:"&COUNT(A2:G2))))))

qcw811206

{=SMALL(ABS(LARGE(A2:G2,ROW(INDIRECT("$1:$"&COUNT(A2:G2))))-A2:G2),COUNT(A2:G2)+1)}