# Listing Top 10 with multiple same name entries

#### vjsarma

##### New Member
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!

Thank you!

### Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
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!

Thank you!

Given Data:

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

Replies
7
Views
180
Replies
1
Views
201
Replies
2
Views
210
Replies
0
Views
676
Replies
8
Views
1K

1,206,757
Messages
6,074,760
Members
446,084
Latest member
WalmitAal

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back