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

[TABLE="width: 1000"]
<tbody>[TR]
[TD]store location[/TD]
[TD]Created on[/TD]
[TD]Quantity[/TD]
[TD]Article Number[/TD]
[/TR]
[TR]
[TD]1002[/TD]
[TD]10/09/2017[/TD]
[TD]3[/TD]
[TD]10734567[/TD]
[/TR]
[TR]
[TD]1002[/TD]
[TD]10/10/2017[/TD]
[TD]4[/TD]
[TD]10734567[/TD]
[/TR]
[TR]
[TD]1002[/TD]
[TD]10/10/2017[/TD]
[TD]5[/TD]
[TD]10322678[/TD]
[/TR]
[TR]
[TD]4002[/TD]
[TD]10/11/2017[/TD]
[TD]4[/TD]
[TD]10322678[/TD]
[/TR]
[TR]
[TD]4002[/TD]
[TD]10/11/2017[/TD]
[TD]10[/TD]
[TD]10322678[/TD]
[/TR]
</tbody>[/TABLE]

As you see, each row indicates a transaction a store

What I want is following:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Article Number[/TD]
[TD]Ranking[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][Input][/TD]
[TD]Top Store Rank 1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Top Store Rank 2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Top Store Rank 3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Top Store Rank 4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Top Store Rank 5[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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!