Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to combine data and delete rows
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to combine data and delete rows
Why not create a pivot table from this data in order to sum the
contributions... that is a whole pile easier and more flexible than code... -- HTH... Jim Thomlinson "PARSguy" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
combine rows and sum data with the same id | Excel Discussion (Misc queries) | |||
How do I combine multiple rows with like data in Excel? | Excel Discussion (Misc queries) | |||
Combine Data from Multiple Rows | Excel Discussion (Misc queries) | |||
Combine data rows in Pie Chart | Charts and Charting in Excel | |||
Combine rows of data in a worksheet | Excel Programming |