|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
本帖最后由 sangshen168 于 2011-11-28 13:02 编辑
如题,如何在多列数据中比较找出多个数值的近似值。如附加中的数据:第一列9V中有842个数值 第三列36V中630个数值第五列37V中有770个数值.....,如何使与第一列中的数值近似的数值在第三和第五列中显示出来;近似的条件是:相差正负0.0005。
9V | | 36V | | 37V | | 203.0517 | 0.024931 | 203.0516 | 0.031038 | 203.0516 | 0.017752 | 203.0526 | 0.04188 | 203.0525 | 0.060673 | 203.0525 | 0.041127 | 219.0265 | 0.010933 | 229.2162 | 0.014689 | 235.1794 | 0.518051 | 229.2162 | 0.02093 | 231.2106 | 0.01662 | 235.1804 | 0.696413 | 233.1511 | 0.017142 | 235.1794 | 0.640417 | 236.1827 | 0.086297 | 235.1795 | 0.586795 | 235.1804 | 0.8524 | 236.1838 | 0.101171 | 235.1805 | 0.76022 | 236.1828 | 0.101171 | 237.2212 | 0.01829 | 236.1829 | 0.10108 | 236.1838 | 0.131295 | 254.8236 | 0.036981 | 236.1838 | 0.12056 | 237.2202 | 0.022589 | 255.2306 | 0.026914 | 237.2203 | 0.019292 | 237.2213 | 0.020826 | 255.2317 | 0.035872 | 237.2213 | 0.029041 | 254.8236 | 0.020663 | 256.8196 | 0.027193 | 254.8227 | 0.025032 | 255.2307 | 0.035008 | 256.8207 | 0.038225 | 254.8237 | 0.037278 | 255.2318 | 0.042176 | 257.1613 | 0.049171 | 255.2308 | 0.032494 | 256.8195 | 0.014525 | 257.1624 | 0.042131 | 255.2318 | 0.043444 | 256.8206 | 0.018232 | 257.2463 | 0.084495 | 256.8196 | 0.026907 | 257.1613 | 0.032358 | 257.2474 | 0.114481 | 256.8207 | 0.050402 | 257.1624 | 0.037952 | 258.2506 | 0.022785 | 257.1614 | 0.025113 | 257.2462 | 0.070563 | 258.8176 | 0.025325 | 257.1624 | 0.038625 | 257.2473 | 0.148661 | 260.8741 | 0.019523 | 257.2464 | 0.08265 | 258.2508 | 0.019319 | 261.011 | 0.028237 | 257.2474 | 0.135006 | 258.8177 | 0.012761 | 263.2367 | 0.021504 | 258.2498 | 0.017771 | 261.01 | 0.032411 | 265.2525 | 0.032026 | 258.2509 | 0.024207 | 261.0111 | 0.041511 | 267.1565 | 0.019872 |
|
|