Home » Category » Microsoft Excel

Microsoft Excel: zip code and +4 duplicates

205| Thu, 22 May 2008 18:44:00 GMT| anonymous| Comments (3)
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?action=getinfo&userid=29948
View this thread: http://www.excelforum.com/showthread.php?threadid=530734

Keywords & Tags: zip, code, +4, duplicates, microsoft, excel

URL: http://www.developertags.com/microsoft-excel/495071/
 
«« Prev - Next »» 3 helpful answers below.
On Thu, 6 Apr 2006 16:46:58 -0500, darkwood
<darkwood.25v4da_1144360201.0678...excelforum-nospam.com> 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

ron | Thu, 22 May 2008 18:46:00 GMT |

The pivot table worked perfectly.

Thanks
--
darkwoo
----
darkwood's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2994
View this thread: http://www.excelforum.com/showthread.php?threadid=53073

darkwood | Thu, 22 May 2008 18:47:00 GMT |

On Fri, 7 Apr 2006 11:43:54 -0500, darkwood
<darkwood.25wkx0_1144428303.0615...excelforum-nospam.com> wrote:

>The pivot table worked perfectly.
>Thanks!

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

ron | Thu, 22 May 2008 18:48:00 GMT |

Microsoft Excel Hot Answers

Microsoft Excel New questions

Microsoft Excel Related Categories