Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to sum contents of duplicate rows
Hi:
I have a worksheet with two columns and multiple rows. Column 1 has Names and column 2 has salary. Charles 15 John 20 John 15 Peter 50 I woul like to see (end result) something like this (note duplicate gone but salary summed up) Charles 15 John 35 Peter 50 Thank You Regards Charles |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove Duplicate rows? | Excel Discussion (Misc queries) | |||
Remove duplicate rows based on 1 specific criterion | Excel Discussion (Misc queries) | |||
Delete rows with duplicate values | Excel Worksheet Functions | |||
Deleting duplicate rows | Excel Discussion (Misc queries) | |||
Duplicate Rows | Setting up and Configuration of Excel |