Easy Frequency Counts?

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

 

[Dave Peterson]

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.