vlookup or what?
 

I have a little database which arrives periodically, and I would like to
chart the number of members by nation. I can't recall ever having this
opportunity before. The nations are standard ISO codes (UA, UK, US, UY)
and not numeric. Is there a way to organize these entries somewhat
automatically for charting?

Alternately, I wondered if I filtered the nation column, is there a way
to export all the unique entries, preparatory to counting this by hand
(so to speak) . . .

Any advice would be gratefully appreciated.
--

Regards,

P D Sterling
New York, Texas & Texas, New York

vlookup or what?
 

PD,

Select the data, then use Data / Pivot Table... and click OK. Then drag the country code column
header button to both the row area and the data area, and Excel will create a summary table of
counts.

HTH,
Bernie
MS Excel MVP


"P D Sterling" wrote in message
...
I have a little database which arrives periodically, and I would like to chart the number of
members by nation. I can't recall ever having this opportunity before. The nations are standard ISO
codes (UA, UK, US, UY) and not numeric. Is there a way to organize these entries somewhat
automatically for charting?

Alternately, I wondered if I filtered the nation column, is there a way to export all the unique
entries, preparatory to counting this by hand (so to speak) . . .

Any advice would be gratefully appreciated.
--

Regards,

P D Sterling
New York, Texas & Texas, New York

vlookup or what?
 

Bernie Deitrick wrote:
PD,

Select the data, then use Data / Pivot Table... and click OK. Then drag the country code column
header button to both the row area and the data area, and Excel will create a summary table of
counts.

HTH,
Bernie
MS Excel MVP


"P D Sterling" wrote in message
...
I have a little database which arrives periodically, and I would like to chart the number of
members by nation. I can't recall ever having this opportunity before. The nations are standard ISO
codes (UA, UK, US, UY) and not numeric. Is there a way to organize these entries somewhat
automatically for charting?

Alternately, I wondered if I filtered the nation column, is there a way to export all the unique
entries, preparatory to counting this by hand (so to speak) . . .

Any advice would be gratefully appreciated.
--

Regards,

P D Sterling
New York, Texas & Texas, New York


wow - I heard of that, but I never used it - thanx for the tip!!!

--

Regards,

P D Sterling
New York, Texas & Texas, New York

vlookup or what?
 

Bernie Deitrick wrote:
PD,

Select the data, then use Data / Pivot Table... and click OK. Then drag the country code column
header button to both the row area and the data area, and Excel will create a summary table of
counts.

HTH,
Bernie
MS Excel MVP


"P D Sterling" wrote in message
...
I have a little database which arrives periodically, and I would like to chart the number of
members by nation. I can't recall ever having this opportunity before. The nations are standard ISO
codes (UA, UK, US, UY) and not numeric. Is there a way to organize these entries somewhat
automatically for charting?

Alternately, I wondered if I filtered the nation column, is there a way to export all the unique
entries, preparatory to counting this by hand (so to speak) . . .

Any advice would be gratefully appreciated.
--

Regards,

P D Sterling
New York, Texas & Texas, New York


Just a note to say, this worked so well, it was frightening. I guess you
learn something every day, and I was thrilled with this! Found out that
my non-responders were only 3% and that's good enough for government
work! Thanks for posting!

--

Regards,

P D Sterling
New York, Texas & Texas, New York