寻找接近数字

killerdh · 发表于 2024-8-31 17:11

如何寻找接近数字，江湖救急！

edwin11891 · 发表于 2024-8-31 17:16

=TAKE(SORT(FILTER(C2:C367,C2:C367>=169733),,1),1)

=TAKE(SORT(FILTER(C2:C367,C2:C367<=169733),,-1),1)

liujing_hotwind · 发表于 2024-8-31 17:25

本帖最后由 liujing_hotwind 于 2024-8-31 17:27 编辑

=MIN(IF(C:C>169733,C:C,10^10))
=MAX((C:C<169733)*C:C)

inrever · 发表于 2024-8-31 17:26

=LOOKUP(,0/IF(SORT(C2:C367,,-1)>=169733,SORT(C2:C367,,-1)),SORT(C2:C367,,-1))
=LOOKUP(,0/IF(SORT(C2:C367)<=169733,SORT(C2:C367)),SORT(C2:C367))

邹永鸿 · 发表于 2024-8-31 17:32

复制代码

沈默00 · 发表于 2024-8-31 17:40

H14=XLOOKUP(169733,C:C,C:C,,1)
H115=XLOOKUP(169733,C:C,C:C,,-1)

jerrike · 发表于 2024-8-31 18:10

本帖最后由 jerrike 于 2024-8-31 18:13 编辑

复制代码

leepoison · 发表于 2024-8-31 18:27

=INDEX(C2:C367,XMATCH(169733,C2:C367,{1,-1}))

quqiyuan · 发表于 2024-8-31 18:49

=INDEX(C2:C367,MATCH(1,FREQUENCY(0,C2:C367-169733),))
=INDEX(C2:C367,MATCH(1,FREQUENCY(0,-(C2:C367-169733)),))

killerdh · 发表于 2024-9-1 02:32

如何在自动在A2区域内寻找169733接近的数（包括大于接近及小于接近）

		自动登录	找回密码
密码			免费注册

[求助] 寻找接近数字