Find uniques in a column, list them in a new column with their totals added up (Excel 2007)

[riteon]

Hello, I have a very long list like below;

Keys	£ 24.50
Windows	£ 4,320.00
Scaffolding	£ 960.00
Rubbish Garden & House Clearance	£ 204.00
Driveway	£ 4,400.00
Rubbish Garden & House Clearance	£ 145.00
Butter	£ 2,990.00
Fencing	£ 4,140.00
Rubbish Garden & House Clearance	£ 2,000.00
Butter	£ 510.00
Plumb	£ 1,891.65
Windows	£ 630.00
Plumb	£ 630.00

In columns A & B

I would like to have all the uniques placed in column C, that lists them alphabetically and added up.

e.g.
Butter would be £3500
Plumb would be £2521.65
Rubbish Garden & House Clearance = £2349
Windows would be £4950

etc. etc. I am still using Excel 2007 if that makes any difference.

Thanks in advance

 

[Sanjeev1976]

Book2
	A	B	C	D
1	List		Unique Values
2	Keys	£24.50	Butter	£3,500.00
3	Windows	£4,320.00	Driveway	£4,400.00
4	Scaffolding	£960.00	Fencing	£4,140.00
5	Rubbish Garden & House Clearance	£204.00	Keys	£24.50
6	Driveway	£4,400.00	Plumb	£2,521.65
7	Rubbish Garden & House Clearance	£145.00	Rubbish Garden & House Clearance	£2,349.00
8	Butter	£2,990.00	Scaffolding	£960.00
9	Fencing	£4,140.00	Windows	£4,950.00
10	Rubbish Garden & House Clearance	£2,000.00
11	Butter	£510.00
12	Plumb	£1,891.65
13	Windows	£630.00
14	Plumb	£630.00
Sheet1

Cell Formulas
Range	Formula
C2:C14	C2	=IFERROR(INDEX($A$2:$A$14, MATCH(SMALL(IF(COUNTIF($C$1:C1, $A$2:$A$14)=0, COUNTIF($A$2:$A$14, "<"&$A$2:$A$14), ""), 1), COUNTIF($A$2:$A$14, "<"&$A$2:$A$14), 0)),"")
D2:D14	D2	=IF(C2<>"",SUMIF($A$2:$A$14,$C2,$B$2:$B$14),"")
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[riteon]

Genius! Many thanks Sanjeev!

 

[Sanjeev1976]

You are welcome Riteon