Creating a table which shows top ranked stores by product

[SirRobin85]

Hello everyone,

I already tried different combinations of Large(row)) or Max functions, but I just can't get it work.
I am happy with whatever I get; the whole solution doesn't have to fit in a formula in one single cell. If I have to create a helper table, I am fine with that.

What I have is data output in following format

Sales information

store location	Created on	Quantity	Article Number
1002	10/09/2017	3	10734567
1002	10/10/2017	4	10734567
1002	10/10/2017	5	10322678
4002	10/11/2017	4	10322678
4002	10/11/2017	10	10322678

<tbody>
</tbody>

As you see, each row indicates a transaction a store

What I want is following:

Article Number	Ranking
[Input]	Top Store Rank 1
	Top Store Rank 2
	Top Store Rank 3
	Top Store Rank 4
	Top Store Rank 5

<tbody>
</tbody>

As you see, the number of rows for doesn't change and that overview table is in a separate spreadsheet. I am not only struggling to rank it, but also to sum it up for a given article and then return the store with the highest quantities sold in the field [Top Store Rank 1], the following store in [Top Store Rank 2],.....

I am also wondering how I would deal with stores which sold the same amount; i.e. if there are 6 stores which have sold each in total.


Thank you very much for your help!