Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a very large list of addresses that I have sorted by zip code. Now I
want to take the zip code column and find out how many addresses per zip code. Example: there are 200 different zip codes, zip code 12478 has 14 repeats, zip code 12903 has 67 repeats...... and can it chart each zip code with its repeat?. Is this a sort, filter, or a combin function. Can someone give me a formula and instruct me where to go in Excel 2007. I know this should be a simple formula but I hardly ever work with excel. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I sort e-mail addresses? | Excel Discussion (Misc queries) | |||
How do I sort mailing addresses in Excel? | Excel Discussion (Misc queries) | |||
Help! How to sort addresses by street then by #...... | New Users to Excel | |||
How do I sort a column of IP addresses ? | Excel Worksheet Functions | |||
How do I sort addresses in excel? | Excel Worksheet Functions |