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
-----Original Message-----
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




.

have a look at PivotTables.
plenty to find in help. plenty to find on google.

keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Rasmus" wrote:

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

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.
-----Original Message-----
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




.