logo2023

沃尔沃:郑老师,如何从下表中抓取出收入的前五名?

郑老师,如何从下表中抓取出收入的前五名?

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))