Prioritizing SKU'S based on Power and Potential

Hi All,

Hope you are doing well!... I am trying to prioritize SKU's based on the power and the Sales by each vendor...Following is the rule that I am trying to build to get the priority column in my excel sheet attached (highlighted in my excel sheet attached)...

For Each Vendor
-> SKU'S with higher power should be given higher priority and only Sales SKU'S should be given higher priority and the priority of the Non Sales SKU'S should follow after the Sales SKU'S are prioritized ...

Sales 0 implies the SKU did not have Sale...

Can you please help here!...



Thanks,
Arun

one option, if I've understood, and based on sample file/values...

Formula:

Please Login or Register  to view this content.

Hi Xlent,

Thanks very much !..This works!!...Appreciate your help!..

Thanks,
Arun

Hi Bo_Ry.

Thanks much!...Appreciate your help!

Thanks,
Arun