Labels and values associated with Top-N values in a range

In this spreadsheet (worksheet 'Aggregate') I am looking for a way to list the Top-10 from the values from columns like US, U etc. on the right. So for instance in Column N, I'd want the To-10 words from column A that have the highest value in column B (US) listed in declining order with the corresponding actual values from Column B next to them. Could anybody please help me in finding the right formula? Thanks!

Hoi Oeldere!'

Dank. But it's not exactly what I wanted. You now have the values rankordered. But what I would like to have are the actual words from column A in that column, with these values next to them. And then the next column would have the top-N words for Column C, with THEIR values next to them, and so on.

run the top10 macro

Wow! This is amazing. Thanks so much rcm. And can this macro also run on other worksheets? They all have the same structure, with the one exception that the length of the columns might differ.

1. If the column named COUNT could be at the end of the countries one could determine how many countries need to be computed, and also determine when to start filling the countries top-10 (this is not coded yet)

2. The width of each column can be self adjusted with the instruction => .autofit so no problems with the column with. I'll add this feature to the macro.

I parametized all variables in the GIVENS tab just need to fill the A2,B2,C2 and hit the BUTTON in the chosen tab

My apologies for asking this again - but just out of curiosity; IS doing such a thing possible without a macro and with just a formula as well, or not?

Looks excellent! And it seems to work like a charm for the US.
=INDEX($A$2:$A$966,MATCH(LARGE(($B$2:$B$966)+ROW($B$2:$B$966)/1000,ROW()-2),($B$2:$B$966)+ROW($B$2:$B$966)/1000,0))

But when I try to adapt the formula for another column (e.g. the UK, which is in the C column), I try to just replace all the 'B's with 'C's in the formula, but I then get an error message. If I would understand the 'logic' of the formula, I'd probably be able to figure it out, but I'm afraid I do not. Can anybody please just explain which changes have to be made in order to make them all work? Thanks!

Looks excellent! I'll start trying it out! Thanks much...

Haaaa! I figured it out. These are of course array formulae that require Ctrl-Shift-Enter! Silly me. And man you guys are good!!!