Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select a list in 1 cell by selecting an item from another list in | Excel Discussion (Misc queries) | |||
Selecting and copying from a list | Excel Discussion (Misc queries) | |||
Selecting an item from a list | New Users to Excel | |||
Selecting from a list | Excel Discussion (Misc queries) | |||
How to create list on another tab by selecting qty from big list? | Excel Worksheet Functions |