Top 10 and Bottom 5 Formula

**pauldaddyadams** · 12-04-2011, 03:56 PM

Hi Guys

I had the two formulas below which were working which would find the top 10 and bottom 5 customers based on margin (column A on the “CSV” sheet).

Top 10 Formula:

Please Login or Register  to view this content.

Bottom 5 Formula

Please Login or Register  to view this content.

However due to a change in the CSV file it is no longer working. Originally the plan was to have the CSV file to show data for one month however it is now going to be show data for all months.

What I am trying to achieve is the user selects the month in column Y16 on the report sheet and the formula returns either the top 10 or bottom 5 customers for that particular month from the data on the “CSV” tab (this is a change to what I originally required).

The formulas would go in the cells I have highlighted in red.

In the green highlighted cells I would like that to return a % based on the total sales from “Unique” Sheet data table but that’s not as important.

I have uploaded the file I am referring to.

Can anyone help please?

Paul

**pauldaddyadams** · 12-05-2011, 03:29 AM

Hi,

Can anyone help with this?

On the unique sheet I have a code which returns the last row of the data on the csv sheet for a given month. Just wondering if that code can be combined with the codes above?

These are the two codes:

Please Login or Register  to view this content.

And (Top 10)

Please Login or Register  to view this content.

Paul

**pauldaddyadams** · 12-05-2011, 11:09 AM

Hi,

Anyone? If you don’t know the full solution and know roughly what I require please post so I can get googling for a solution myself. This is what I think I need (could be wrong)
A formula to sum every third row for the CSV sheet
An index and match formula to match the month selection on the report tab and the "csv" data sheet.
A large formula

Any help will be greatly appreciated, I am getting desperate!