excel中,有 15,2,55,4,78,9,8,9,78,75,5,65,5,55,5,46,44,75,54,2,
excel中,有 15,2,55,4,78,9,8,9,78,75,5,65,5,55,5,46,44,75,54,2,52,55,64,45,22,54,54,55,75,5.
用什么公式可以提取这组数据中最大的5 个数据
本列中为55,78,78,75,65,55,75,55,64,55,75
A 列 B列
15x0555
2x0578
55x0578
4x0575
78x0565
9x0555
8x0575
9x0555
78x0564
75x0555
5x0575
65x05
5x05
55x05
5x05
46x05
44
75
54
2
52
55
64
45
22
54
54
55
75
5
效果如图所示