| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
copying matched data, sort of
I have files that contain a header row and then thousands of rows of data.
Column A is a customer identifyer label that is unique. There's only 1 row per customer. EXCEPT for my problem. In some cases, we've repeated the rows to split off have of the data in the other cells to be assigned to 1 salesman amd the other half to another salesman. Now I need to merge them all back together so that... X12345 100 2000 Smith Jones X12345 100 2000 Smith Miller Y12345 300 3000 Johnson Howard becomes.... X12345 200 4000 Smith Miller Y12345 300 3000 Johnson Howard So the amounts are added and the name that appears first is the one that is used. Is there an easy way to do this? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get a hyperlink (entire row) to data sort alphabetically | Excel Worksheet Functions | |||
| sort 2 or more rows of cells linked to one row of data | Excel Worksheet Functions | |||
| Removing blank rows in a worksheet | Excel Worksheet Functions | |||
| How do I make a formula refer to given data even if I do a sort f. | Excel Discussion (Misc queries) | |||
| Data > Sort function amnesia? | Excel Discussion (Misc queries) | |||
Threaded Mode
