Quick 'report' - how do I get started ?

  • Thread starter Thread starter Rasmus
  • Start date Start date
R

Rasmus

I have a sheet with two columns looking like this:

Column A = Quantity (can be any positive number)
Column B = Country (can be any country in the world)

If I have, say 500 rows with a lot of different values in column A and maybe
50 different countries in column B, then how do I get started with a
nice-and-easy-and-relatively-short VBA code that shows a msgbox with the
following information:

There was 120 items found for USA
There was 55 items found for Canada
There was 22 items found for United Kingdom
etc.

I hope I'm making it kind of clear what I'm trying to accomplish.

Any help would be much appreciated.

(c:
Rasmus
 
For a formula solution - look at countif and sumif.

HTH & Cheers

Adolph
 
Several people have indicated non-code oriented
solutions. If it is not important that you sort the data,
then another non-code solution is to sort it by Country
and do subtotals with a count and collapse it. Is this a
problem? Is is a problem to sort it? A message box with
some 50 lines is a big message box, not really sure what
the limits are there.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to sum the 3 best scores for each country in a contest? 2
SUM - IF - AND 7
Sussex where...? 8
How can I work out percentages of a particular column? 1
Recreating a pivot table using code 1
Reading values into an array of User Defined Types 7
Strip out certain rows that have merged cells 2
How do I pull variable URL from one column and download the contentto another column? 3

Back
Top