"Peo Sjoblom" wrote in message
...
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.





Excellent. Thanks Peo.

--
Larry Wallis.