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