| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Collating Duplicate Rows Keeping all values intact and updating Qu
On a daily basis I have to generate several workbooks that end up with
duplicate rows. I need to combine the duplicate part numbers and add the QTYS keeping everything else intact. Can someone please help me. I have been manualy updating these for a few days and it take hours as they have up to 250 rows each. Part# MATERIAL RT# Item QTYS 70M0293 10GA HR 46287 F-WBOOM 2 70M0293 10GA HR 46287 F-WBOOM 2 D6M0104 7GA HR A572 46332 WB BOOM 3 D6M0104 7GA HR A572 46332 WB BOOM 3 -- TimP |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Keeping Formulas Intact While Sorting | Excel Discussion (Misc queries) | |||
| Keeping formula format intact | Excel Discussion (Misc queries) | |||
| keeping rows intact during sort | Excel Discussion (Misc queries) | |||
| Keeping a series table from updating when adding new rows. | Charts and Charting in Excel | |||
| Keeping duplicate rows | Excel Worksheet Functions | |||
Threaded Mode
