Help with Weighting Rank Function by Another Column

[steveocaffey]

Hello,

I am hoping some of you smart folks can help me with a little problem I am having with weighting the Rank function by another column. In the attached file, there is a hypothetical company owning 18 car dealerships. I am calculating the yearly change in sales and then computing an unweighted rank in Col J. Next, I want to calculate a weighted rank (Col K) for that same yearly change but weighted by the inventory (Col C & D). I am uncertain if my approach works as calculated in Col K. The main goal is to weight the year-over-year percent change in sales by the available inventory and then rank the sales (smaller inventory can lead to larger % change).

Thank you.

Steve