|
向各位老师请教:
附件中B列中有正数也有负数,怎样使用函数筛选出绝对值最大的三个数和对应的Material
Material | Amt | | SCMR0033 | -3,518.43 | 14 | SCMR0011 | -2,937.24 | 12 | SCMR0048 | 18.79 | 2 | SCMR0024 | -23,036.00 | 16 | 09550121 | -22,275.00 | 15 | SCMR0109 | -544.00 | 8 | SCMR0114 | -250.80 | 6 | SCMR0115 | -386.40 | 7 | 09552045 | -1,071.00 | 9 | 09550203 | -2,849.00 | 11 | SCMR0010 | -46,080.00 | 17 | 09551585 | -3,444.00 | 13 | SCMR0042 | -2.40 | 1 | SCMR0044 | 30.85 | 3 | SCMR0043 | -94.08 | 5 | SCMR0041 | -47.00 | 4 | SCMR0036 | -2,106.00 | 10 |
要达到的效果:
| Material | Amt | 1 | SCMR0010 | -46,080.00 | 2 | SCMR0024 | -23,036.00 | 3 | 09550121 | -22,275.00 |
|
|