| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
Select the part numbers header included, do datafilteradvanced filter,
select unique records only and copy to another location, assume that the original part numbers are in A1:A1000, assume that you copied the unique list to H1:H200, now in I2 put =SUMIF($A$2:$A$1000,H2,$C$2:$C$1000) copy down all adjacent unique records -- Regards, Peo Sjoblom "Larry Wallis" wrote in message ... 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
