| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 | |||
| Creating a dynamic list | Excel Worksheet Functions | |||
| Comparing two List that a "Close" but not Identical | Excel Worksheet Functions | |||
| Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
| How do I find out what items are in one list but not in another l. | Excel Discussion (Misc queries) | |||
| Creating a list from an existing list. | Excel Worksheet Functions | |||
Threaded Mode
