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