Easy Frequency Counts?

  • Thread starter Thread starter Thomas Kossler
  • Start date Start date
T

Thomas Kossler

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top