View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
J Pol J Pol is offline
external usenet poster
 
Posts: 1
Default Grouping/Counting/Concentrations

I have a worksheet with some 30,000 rows of data. This worksheet consists of
columns with the information: FirstName, LastName, City, State, Country,
etc...

-I would like to find the top 50 to 60 cities with the most number of users.
-Can I also somehow include different spellings for the cities such as "St
Louis", "St. Louis", "Saint Louis", and misspells "Saint Luis?"
-Can I group this information in a chart/table/ or graph consisting of City,
State, Number of Users, and percentage of the whole?

Help would be greatly appreciated