zip code and +4 duplicates
 

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


--
darkwood
------------------------------------------------------------------------
darkwood's Profile: http://www.excelforum.com/member.php...o&userid=29948
View this thread: http://www.excelforum.com/showthread...hreadid=530734

zip code and +4 duplicates
 

On Thu, 6 Apr 2006 16:46:58 -0500, darkwood
wrote:


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

zip code and +4 duplicates
 

The pivot table worked perfectly.

Thanks!


--
darkwood
------------------------------------------------------------------------
darkwood's Profile: http://www.excelforum.com/member.php...o&userid=29948
View this thread: http://www.excelforum.com/showthread...hreadid=530734

zip code and +4 duplicates
 

On Fri, 7 Apr 2006 11:43:54 -0500, darkwood
wrote:


The pivot table worked perfectly.

Thanks!

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