Excel 2007 : Help with create a top 15 table from a sheet of data automatically

[krisedwards]

Hi guys

i have a sheet of data about 10,000 cells, with multiple columns.

I am wanting to create a top 15 table automatically from the sheet of data.

The example that I have attached has different days and different people with different amount of sales.

So basically what I want to do is sort them from the sheet of data to a table of top 15 on a different page. This is for total sales so it will have to sum up the amount of sales for each person and then sort them from highest to lowest

Thanks

attachment below:
data sheet example.png

[kakapoo]

Hello,

do you need help with Excel? If so, post an Excel file.

If you post an image, all we can do is point you to a Photoshop forum to help you manipulate the image.

It's actually a lot less effort to post the underlying Excel file instead of a picture of the Excel file.

Anyway: You can use a pivot table to do what you require. Post your data as an Excel file and we can work with it.

[krisedwards]

uploaded an example of the document i am using


how would I get the pivot table to then calculate the sum of all sales by one person and then rank them??

[Fotis1991]

Hi

A (almost) simple way to do this, is using 2 helpers and hidden(if you like) columns.

So in column F, type(or copy your names), starting from F2.

In G2, put this.

Please Login or Register  to view this content.

[/CODE]

Copy down.

In J2, put this and copy down, changing the red number, to 2,3,4......

Please Login or Register  to view this content.

In I2, put this and copy down.

Please Login or Register  to view this content.

We are ready.

Change the semi-colons to comma, if you have to do this.

[JosephP]

create the pivot with person as row field, sales as data field, then filter the person field for top 15 by sales.