To auto-generate top 3 name list

[Terence Chan]

Dear all, see any body can help !

I have a list with expenses list by a group of employees for the week:

_Day_ _Staff__ _Claim_Amount_1
1 A 10
2 B 10
2 A 10
3 B 10
3 A 10
4 C 10
4 D 5
5 E 5
5 F 2


_Expected_Result_

TOP 3 STAFF WHO MADE HIGHEST CLAIM FOR THE WEEK

_Staff__ _Total_Amounts_Claim_

A 30
B 20
C 10

Problem : How to find out the top 3 emplyees who make highest claims
for the week, subtotal of each employee's claims and rank it in
descending order ?

Of course I can subtotal the data by employee name first and rank it
mannually, but how to perform it more quickly and effectively ?

Thanks in advance for those can concern and help.

 

[Debra Dalgleish]

You can create a pivot table from the data, and show the top three results.

To create a pivot table:

Select a cell in the table
Choose Data>PivotTable and PivotChart Report
Click Next, click Next
In Step 3, click the Layout button
Drag Staff to the Row area, and Claim Amount to the Data area
Double-click the Staff button, and click the Advanced button
For Top Ten AutoShow, select On, and set the number to 3
Click OK, OK, OK, Finish