Listing Top 10 with multiple same name entries

[vjsarma]

I have an worksheet with expenses for different items with name, date, receipt no., total etc.

I need to create a top 10 list of expenses but when I sort I get only the Top 10 INDIVIDUAL receipts while I need all receipts under the same name to be added together and then listed.

For eg.
Name of expense(Column A) Cost (Col.B)

Transport $1000
Gas $2000
Transport $800
Food $1100
Transport $500
Electricity $700

I have 100 lines per sheet like this with many more names, when I do a top 10 I get -

1.Gas - $2000
2.Food - $1100
3.Transport - $1000
etc.
Whereas Transport should be on top as it costs added up is more than the others.

It will help monitor the highest cost which is done manually right now. The data is sorted but not able to get a top 10 list!
Your help is much appreciated in advance!

Thank you!

 

[Sal Paradise]

I have an worksheet with expenses for different items with name, date, receipt no., total etc.

I need to create a top 10 list of expenses but when I sort I get only the Top 10 INDIVIDUAL receipts while I need all receipts under the same name to be added together and then listed.

For eg.
Name of expense(Column A) Cost (Col.B)

Transport $1000
Gas $2000
Transport $800
Food $1100
Transport $500
Electricity $700

I have 100 lines per sheet like this with many more names, when I do a top 10 I get -

1.Gas - $2000
2.Food - $1100
3.Transport - $1000
etc.
Whereas Transport should be on top as it costs added up is more than the others.

It will help monitor the highest cost which is done manually right now. The data is sorted but not able to get a top 10 list!
Your help is much appreciated in advance!

Thank you!

Given Data:

Excel 2003
	A	B
1	Item	Expense
2	Transport	$1,000
3	Gas	$2,000
4	Transport	$800
5	Food	$1,100
6	Transport	$500
7	Electricity	$700
8	Travel	$4,000
9	Food	$600
10	Household Goods	$2,700
11	Electricity	$100
12	Electronics	$3,500
13	Household Goods	$2,800
14	Electronics	$1,300
15	Gas	$3,500
16	Transport	$1,500
17	Electricity	$2,800
18	Electronics	$300
19	Water	$3,100
20	Food	$400
21	Transport	$300
22	Water	$3,400
23	Water	$1,200
24	Gas	$300
25	Food	$3,300
26	Gas	$1,600
27	Transport	$900
28	Gas	$800
29	Travel	$700
30	Household Goods	$1,800
31	Gas	$2,200
32	Electricity	$3,400
33	Water	$3,200
34	Household Goods	$2,900
35	Water	$2,100
36	Household Goods	$3,600
37	Travel	$2,200
38	Electronics	$700
39	Transport	$3,700
40	Gas	$3,500
41	Entertainment	$1,000
42	Electronics	$1,000
43	Food	$3,700
44	Other	$2,900
45	Water	$900
46	Household Goods	$2,600
47	Gas	$2,700
48	Household Goods	$500
49	Other	$700
50	Travel	$2,900
51	Other	$1,800
Sheet1

You can select the data, and make a pivot table, then sort by total expenses. That's probably easiest I'd think.