郑老师,如何从下表中抓取出收入的前五名?
No. Region Dealer Sales (M CNY)
Feb March
1 East ABC 13.9 38.5
2 East BCD 64.1 97.0
3 East AAD 41.1 44.3
4 East DBC 24.3 35.2
5 East AVV 2.1 2.8
6 East WDD 56.7 95.1
7 East HZH 36.0 83.1
8 East ZJL 24.8 45.6
结果
Dealer Sales
Feb
BCD 64.1
WDD 56.7
AAD 41.1
HZH 36.0
ZJL 24.8
解决方案:
=INDEX($D$5:$D$12,MATCH(LARGE($E$5:$E$12,ROW(A1)),$E$5:$E$12,0))