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
|