Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |