J
J Pol
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
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