Can someone please help me with this query:


I have the following data set, the first row is the week number, the first column is the product. So therefore we have sales by week.

excel.jpg

I want a formulae where I can edit the week number in cell B11 and have returned the top 5 selling fruits of that week, not just the top 5 values from the column.

So my results where B11=1, should look like:


Guava
Melons
Strawberry
Kiwi
Oranges

and NOT:

66
12
11
9
7

I guess I should also give some consideration to if the sales for 2 products were the same, in that case, it should order those results alphabetically.

Thanks Guys!