Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / April 2005

Tip: Looking for answers? Try searching our database.

Easy Frequency Counts?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Thomas Kossler - 30 Apr 2005 14:31 GMT
I have a spreadsheet column with about 4,000 zipcodes extracted from a
mailing list. Many of the zipcodes are multiples. I would like to run some
sort of function to tell me how many instances of each zipcode there are.
I've looked at the "frequency" and "histogram" functions, but they seem to
require buckets or ranges. I need to know the count for each zipcode even if
it is listed only once.

Is there an easy way to do this?

Many thanks.
Dave Peterson - 30 Apr 2005 16:08 GMT
You could add titles, sort by zipcode, then apply data|subtotals to count each
zipcode.

Or you could add titles and use Data|Pivottable.

The data doesn't have to be sorted for the pivottable to count entries.

> I have a spreadsheet column with about 4,000 zipcodes extracted from a
> mailing list. Many of the zipcodes are multiples. I would like to run some
[quoted text clipped - 6 lines]
>
> Many thanks.

Signature

Dave Peterson

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.