I have a spreadsheet with thousands of census data entries and I need to
combine multiple entries based on a social securtity number. An example
is below. I need to combine the contribution colum and the rest of the
info can remain the same while deleting the duplicate entry. Some
people may have more than 2 entries. Can anybody help with a macro
program. Thanks.
Ss# Name contribution Comp Birth date Hire
date
55555555 Doe, John 38.10 508.00 01/01/45 11/01/98
55555555 Doe, John 35.00 508.00 01/01/45 11/01/98
66666666 doe, Jane 22.50 300.00 03/01/60 02/15/06
--
PARSguy
------------------------------------------------------------------------
PARSguy's Profile:
http://www.excelforum.com/member.php...o&userid=36638
View this thread:
http://www.excelforum.com/showthread...hreadid=563915