zip code and +4 duplicates

[darkwood]

I have a request for a file with the total number of accounts that we
have in a certain zip code. Problem is that my system lists 46060 and
46060-1234 as 2 separate zips. So I removed the +4 but I am left with
duplicates for many zips because of the +4. What is the easiest way to
sum up each zip code and add together all of the ones that have
duplicate values and return one total at the first instance of that
particular zip (sorted by zip 00000-99999)? That way I can then go
back and delete all of the dup entries and provide one total for each
unique zip code.

Thanks in advance,

-Scott

 

[Ron Rosenfeld]

I have a request for a file with the total number of accounts that we
have in a certain zip code. Problem is that my system lists 46060 and
46060-1234 as 2 separate zips. So I removed the +4 but I am left with
duplicates for many zips because of the +4. What is the easiest way to
sum up each zip code and add together all of the ones that have
duplicate values and return one total at the first instance of that
particular zip (sorted by zip 00000-99999)? That way I can then go
back and delete all of the dup entries and provide one total for each
unique zip code.

Thanks in advance,

-Scott

Sort your column of 5 digit zips; then use the Data/Subtotals wizard to pull
out what your looking for.

Or you might be able to use a pivot table.
--ron

 

[darkwood]

The pivot table worked perfectly.

Thanks

 

[Ron Rosenfeld]

The pivot table worked perfectly.

Thanks!

Glad to help. Thanks for the feedback.
--ron