Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merging duplicate rows
Hi, Firstly I'd like to thank the people on here for replying so quickly its a great facility I have a problem with a order worksheet in my workbook.. basically, it allows products to be added into a summary, where i lists the model, description and quantity. What I want is to merge the duplicate rows, and increment the quantit field. So if i have 3 rows the same, it will filter to one row and put "3" i the quantity field.. can anyone help..? Mat ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging duplicate lines in a Database | Excel Discussion (Misc queries) | |||
Combining and merging duplicate data. | Excel Discussion (Misc queries) | |||
Merging data in multiple rows where the first cell has duplicate d | Excel Discussion (Misc queries) | |||
merging information from partial duplicate rows | Excel Discussion (Misc queries) | |||
MERGING COLUMNS WITH DUPLICATE INFO. | Excel Worksheet Functions |