| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Match 2 cells and total another
I have a worksheet with 12 columns. I have part # in Column F, Part
Description in Column D and Quantity in Column B. I would like to find all of the part # that match the part description and total the quantity. I may have the same parts and description in several rows. I would also like to combine the rows so I only have 1 row for each part with only the total qty, B D F QTY Part Description Part # 6 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| match total with fees | Excel Worksheet Functions | |||
| match totals with two lists of total | Excel Discussion (Misc queries) | |||
| Loop, Compare, Match & Total | Excel Programming | |||
| Grand total time between two total cells | Excel Discussion (Misc queries) | |||
| Finding combinations to match a total | Excel Discussion (Misc queries) | |||
Linear Mode
