vlookup or what?

P

P D Sterling

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
 
B

Bernie Deitrick

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

P D Sterling

Bernie said:
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
Click to expand...
wow - I heard of that, but I never used it - thanx for the tip!!!

--

Regards,

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

P D Sterling

Bernie said:
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
Click to expand...
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
 
Top