For each code, i want to rank the outlet by qty sold (largest to smallest)

[sillston]

Hello!

I'm trying to determine what code/product should be given to what outlet based on previous sales, for example I want to be able rank largest to smallest, the outlet (column D) by the qty sold (column E) but for each individual code (column A) as each outlet have sold the same products.

I'm aware I can view this through a pivot table but I want to be able to do this every week and vlookup the rank to a different spreadsheet. I've tried several different options like INDEX MATCH with LARGE but nothing seems to have worked.

Any help would be greatly appreciated!