| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to consolidate/sum a list
I have a simple spreadsheet in the following format ...
Cell A1 with a heading Part Number, B1 heading Description and C1 heading Quantity. Under the headings is a list of 100 rows and a part number can appear more than once. What I would like to do is take all the unique part numbers and put them into a separate list and then sum the totals for these part numbers. Can anyone give me and idea how to do this please? Many thanks. -- Larry Wallis. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Consolidate 3 lists with duplicates into one list | Excel Worksheet Functions | |||
| I need to consolidate a list into rows | Excel Discussion (Misc queries) | |||
| Matching items in 2 list to consolidate to one list | Excel Discussion (Misc queries) | |||
| How to consolidate/sum a list | Excel Discussion (Misc queries) | |||
| How to consolidate/sum a list | Excel Worksheet Functions | |||
Threaded Mode
