差距最小二數 (10497)

D2:D3{=SMALL(OFFSET(B$2,,,COUNT(B:B)),RIGHT(MIN(MMULT(SMALL(OFFSET(B$2,,,COUNT(B:B)),ROW(INDIRECT("2:"&COUNT(B:B)))-{1,0}),{-1;1})/1%+ROW(INDIRECT("1:"&COUNT(B:B)-1))),2)+ROW(A1)-1)

區域數組{=LARGE(B:B,RIGHT(MIN(MMULT(LARGE(B:B,ROW(INDIRECT("1:"&COUNT(B:B)-1))+{0,1}),{1;-1})/1%+ROW(INDIRECT("1:"&COUNT(B:B)-1))),2)+{1;0})

區域數組 限三位數{=INT(RIGHT(MIN(MMULT(IFERROR(SMALL(B:B,ROW(1:666)+{0,1}),9^9),{-999000;1000001})),{6;3})/{1000;1})

差距>第 一小  有誤=INDEX(B:B,MATCH(MIN(FREQUENCY(ROW($1:$999),B:B)),FREQUENCY(ROW($1:$999),B:B),)+1)-(ROW(A1)=1)*MIN(FREQUENCY(ROW($1:$999),B:B))