Selecting top-10 from a list

[DJ]

I have a list of countries in one column (b) and a list of responses from
people in each country in another (c). I want to be able to summarise the
top-10 somewhere else on the sheet and need to have a calc that shows number
1 UK - 200 responses, US - 300 responses etc

Any thoughts?

 

[Pecoflyer]

I have a list of countries in one column (b) and a list of response
from
people in each country in another (c). I want to be able to summaris
the
top-10 somewhere else on the sheet and need to have a calc that show
number
1 UK - 200 responses, US - 300 responses etc

Any thoughts?

Hi,
have you tried a Pivot Table

--
Pecoflye

Cheers -

'Firefox 3.5' (http://www.mozilla.com/en-US/firefox/all-beta.html
really IS fast