Ask Your Question
0

how do I find the top 10 values including duplicates along with names.

asked 2019-02-23 02:54:57 +0200

dwood505 gravatar image

I have a list of over 3000 sales persons and I have their sales for the year. I need to find the top 10 sales people along with their sales totals including all duplicates. As the year progresses I want the top 10 list to change when I enter new sales figures or add new sales people. Thanks for any help you can give me.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2019-02-23 10:10:58 +0200

updated 2019-02-23 10:13:07 +0200

Hello @dwood505

This could be easily done using Pivot Table functionality. Please find these Sample spreadsheet attached

Step 1. Assume in columns A to C we have source sales table with Sale person names and amount and date of each deal. I have named this range SalesSource Named range PivotResult is a destination address for Pivot Table pivot1

Step 2. Go to Data -> Pivot Table -> Create, select Named range SalesSource as source pivot2

Step 3. You will see Pivot Table Layout dialog. Drag Sales Person to Row Fields window and Amount to Data Field window. Then click Source and Destination and select Named range PivotResult as Destination pivot3

Step 4 Then double click Sales Person inside Row Fields window and click Options button. You will get Data Field options dialog

pivot4

Step 5. Select Sort by Sum - Amount, sorting Descending, click Show and select how many Top/Bottom items from Sum - Amount you want to be displayed. So, if you want TOP-10, left it 10 and Top using field Sum - Amount. pivot5

Step 6. Click Ok to accept all Pivot parameters and you have the result.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-02-23 02:54:57 +0200

Seen: 30 times

Last updated: Feb 23