ranking with consideration to two different values

**mpattaui** · 11-20-2012, 11:53 PM

Hi,

I am a newbie here. would like to ask for your help.
I am currently preparing the data for warehouse slotting
and one of the requirement is to rank each item product according
to velocity and weight. The slotting should be that all fast moving and
heaviest weight skus should be placed at the shelves A and B, slow moving
and light weights at shelves C and D.
can i get the ranks of both by just getting the average rank by velocity and weight?

thanks!

**TheExcelphile** · 11-21-2012, 03:58 AM

What I would do is to multiply the velocity by weight for each item, and then rank them according to the result.
If you want to know how to do this, upload a sample sheet, and we would help you out.

Don't forget to click the little star to the left of this post if you feel I helped!

**mpattaui** · 11-25-2012, 11:24 PM

Hi Excelphile,

Many thanks for your help. I have uploaded a sample file for your review.

**TheExcelphile** · 11-26-2012, 12:18 AM

Hi mpattauti,

Here is your sample file with the solution put in...sample ranking.xlsx

I've added a helper column, where I take the product of Usage and Weight. I've then used the Rank formula on the helper column.

Don't forget to click on the little star to the left of this post if you feel I helped!