| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting function but not double counting duplicates | Excel Worksheet Functions | |||
| Counting by grouping cells | Excel Worksheet Functions | |||
| Grouping and counting | Excel Discussion (Misc queries) | |||
| Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
| Counting Rows Then Counting Values in Columns | Excel Programming | |||
Threaded Mode
