To auto-generate top 3 name list

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 Amount1
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.

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

Terence Chan wrote:
> 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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html