Selecting top-10 from a list
 

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?
--
DJ

Selecting top-10 from a list
 

DJ;447292 Wrote:
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?
--
DJ

Hi,
have you tried a Pivot Table?


--
Pecoflyer

Cheers -

'Firefox 3.5' (http://www.mozilla.com/en-US/firefox/all-beta.html)
really IS fast !
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=123885