I'm frustrated (or maybe embarrassed) to have to ask this, but I can't
find in Help or a MS Office Pro 2000 book how to calculate the
frequency of unique values (zipcodes) listed in a single column, let
alone put the resultant list in another column (or anywhere empty).
I'd be grateful if someone would point the way. This is Excel 2000.
Thanks.

Gene

Hi!

Use an advanced filter to copy the uniques to another column then use
Countif to get the frequency.

See if you can figure it out from here. If you still need assistance just
post back and I (or someone) will be glad to give you a step-by-step.

Biff

"Gene Goldenfeld" wrote in message
et...
I'm frustrated (or maybe embarrassed) to have to ask this, but I can't
find in Help or a MS Office Pro 2000 book how to calculate the
frequency of unique values (zipcodes) listed in a single column, let
alone put the resultant list in another column (or anywhere empty).
I'd be grateful if someone would point the way. This is Excel 2000.
Thanks.

Gene