How to rank multi criteria by group uniquely?

Cross-posted at https://www.mrexcel.com/board/thread...-2019.1238065/

Hi All,

I would like to sum and rank categories below with multi criterial uniquely.
As you can the the column "Categories Ranking" is the result that I want to have. And before ranking the categories there will be sum of the same categories, Week no., and department also. Example, Apple in Week No 2, Department A, the total is 70$ because there are 2 Apples in the list. However, the result ranking of apple will appear only one, while another apple returns blank.

I hope you understand what I mean.
Thank you!

like this, subtotal per week, dept & cat and then ranking

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

I have added the link in post #1 because you are still a new member.

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking addreputationiconsmall.jpg below their name.