EXCEL里查找最接近的数据,并返回数据:A B C D9:46\x05808.4\x05828.3\x05809.59:48\x05798.5\x05816.4\x05799.89:50\x05786\x05802.4\x057879:52\x05773.5\x05788.9\x05774.69:54\x05761.7\x05776.4\x05762.79:56\x05750.9\x05764.6\x05751.79:58\x05740.

EXCEL里查找最接近的数据,并返回数据:A B C D9:46\x05808.4\x05828.3\x05809.59:48\x05798.5\x05816.4\x05799.89:50\x05786\x05802.4\x057879:52\x05773.5\x05788.9\x05774.69:54\x05761.7\x05776.4\x05762.79:56\x05750.9\x05764.6\x05751.79:58\x05740.
EXCEL里查找最接近的数据,并返回数据:
A B C D
9:46\x05808.4\x05828.3\x05809.5
9:48\x05798.5\x05816.4\x05799.8
9:50\x05786\x05802.4\x05787
9:52\x05773.5\x05788.9\x05774.6
9:54\x05761.7\x05776.4\x05762.7
9:56\x05750.9\x05764.6\x05751.7
9:58\x05740.5\x05753.9\x05741.5
10:00\x05730.8\x05743.8\x05731.9
查找B组中与800最接近的值,并将与A组对应的时间返回(E12)
查找B组中与800最接近的值,并将与B组对应的值返回(F12)
查找B组中与800最接近的值,并将与C组对应的时间返回(G12)
查找B组中与800最接近的值,并将与D组对应的时间返回(H12)

EXCEL里查找最接近的数据,并返回数据:A B C D9:46\x05808.4\x05828.3\x05809.59:48\x05798.5\x05816.4\x05799.89:50\x05786\x05802.4\x057879:52\x05773.5\x05788.9\x05774.69:54\x05761.7\x05776.4\x05762.79:56\x05750.9\x05764.6\x05751.79:58\x05740.
E12公式
=index(a:a,match(min(abs($b1:$b8-800)),abs($b1:$b8-800),))
数组公式以ctrl+shift+enter三键组合结束输入
公式往右拉到H12即可
如果A列是时间格式的,你要把E列也设置为时间格式