How to remove duplicates & add up the quantity?

[musicF]

Hi all,
New here need some help for my job please.

Just need to remove all the duplicates in the column "Title".
All quantity is = to 1.

I would like to remove the duplicates from Title, and add up the quantity to another column if possible.
any help would be great!!

i am using excel 2010 by the way

[AB33]

Use Pivot Table

[musicF]

Use Pivot Table

no idea what that is.
can you provide a link to download?

[ChemistB]

A pivot table is one of Excel's built in capabilities. Try this;

Select a cell within your table, i.e. A1
On the ribbon, Insert Tab> Pivot Table (will be on the left)
Excel will automatically determine your range. and will put the pivot table in a new sheet. Just hit "OK"

From "Pivot Table Field List" grab "Title" and move it down to "Row Labels"
Grab "Quantity" and move it down to SUM Values
Close the Field list.
Voila, you have a pivot table.
Does that work for you?

[Fotis1991]

Another way is using this formula in another column(let's say E). So in E2 and copy down.

=LOOKUP(REPT("Z",5),CHOOSE({1\2},"",INDEX(A$2:A$2741,MATCH(TRUE,INDEX(ISNA(MATCH(A$2:A$2741,E$1:E1,0)),0),0),1)))

Then in your other column use a SUMIF function to add the numbers

=SUMIF($A$2:$A$3000;E2;$B$2:$B$3000) copy down.

[musicF]

A pivot table is one of Excel's built in capabilities. Try this;

Select a cell within your table, i.e. A1
On the ribbon, Insert Tab> Pivot Table (will be on the left)
Excel will automatically determine your range. and will put the pivot table in a new sheet. Just hit "OK"

From "Pivot Table Field List" grab "Title" and move it down to "Row Labels"
Grab "Quantity" and move it down to SUM Values
Close the Field list.
Voila, you have a pivot table.
Does that work for you?

this worked perfectly.
thanks!