Extrapolating a top ten

Every month I use a worksheet that has the following information:

Countries Amount
argentina $5
brazil 10
chile 13
china 54
denmark 8
Finland 23
France 15
India 23
Indonesia 4
Japan 3
Russia 68
south africe 39

The list is actually a lot longer but is there a formula to allow me to extrapilate the top ten amounts without using a macro to sort and filter? I usually use MS Excel help for this but dont even know a keyword to put in here.

use =large(b1:b100,1)
large(b1:b100,2) and so on
but if you have some = amounts and want to retrieve country as well you'll have to unique rank them and extract with an index match

Welcome to the Board.

If for sake of example we assume your sample data in listed in A2:B13 (A1:B1 being headers) and you wish for top 10 values to be listed in D2:D11 then:

D2: =LARGE($B$2:$B$13,ROWS(D$2:D2))
copied down to D11

If you want to retrieve associated country in say E2:E11, and to account for possibility of duplicity of values in B...

E2: =INDEX($A$2:$A$13,MATCH(1,INDEX(($B$2:$B$13=$D2)*ISNA(MATCH($A$2:$A$13,E$1:E1,0)),0),0))
copied down to E11

I forgot to say this but thank you guys for answering my question! I would mark this one solved but i cant edit my original post i dont think!