Ranking Help

bryan3228

New Member
Joined
Jul 30, 2012
Messages
8
Hi There,

I am trying to get a weighted ranking that uses dollars as the highest weighting. We are looking at a list or items and evaluating their weeks spent below their intend MSRP and wanted to rank them by importance using a count of the weeks below MSRP and their YTD Sales to rank them.

I am not sure if what I am asking for is possible. In the attached example, the list is small. In the data set i am working with, there are hundreds of entries.




Weeks
MSRP YTD Volume123456789Count below MSRPDesired Rank
Item11.99 $ 100,000 $ 1.39 $ 1.39 $ 1.39 $ 1.39 $ 1.39 $ 1.39 $ 1.39 $ 1.39 $ 1.3993
Item22.99 $ 150,000 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.84 $ 2.84 $ 2.8435
Item33.99 $ 190,000 $ 3.99 $ 3.99 $ 3.99 $ 3.99 $ 3.99 $ 3.99 $ 3.99 $ 3.99 $ 3.9907
Item44.99 $ 50,000 $ 3.99 $ 3.99 $ 3.99 $ 3.99 $ 3.99 $ 3.99 $ 3.99 $ 3.99 $ 3.9994
Item55.99 $ 250,000 $ 3.59 $ 3.59 $ 3.59 $ 3.59 $ 3.59 $ 3.59 $ 3.59 $ 3.59 $ 3.5992
Item66.99 $ 1,000,000 $ 3.50 $ 3.50 $ 3.50 $ 3.50 $ 3.50 $ 3.50 $ 3.50 $ 3.50 $ 3.5091
Item77.99 $ 75,000 $ 7.99 $ 7.99 $ 7.99 $ 7.99 $ 7.99 $ 7.99 $ 7.99 $ 7.99 $ 7.9908
Item88.99 $ 5,000 $ 4.50 $ 4.50 $ 4.50 $ 4.50 $ 4.50 $ 4.50 $ 4.50 $ 4.50 $ 4.5096

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

steve the fish

Well-known Member
Joined
Oct 20, 2009
Messages
8,072
Office Version
365
Platform
Windows
Im not clear why your rank 5 is higher than your rank 6?
 

steve the fish

Well-known Member
Joined
Oct 20, 2009
Messages
8,072
Office Version
365
Platform
Windows
Try this:

=SUMPRODUCT(--(M3*10^12+C3<$M$3:$M$10*10^12+$C$3:$C$10))+1
 

steve the fish

Well-known Member
Joined
Oct 20, 2009
Messages
8,072
Office Version
365
Platform
Windows
Sure but 9 is larger than 3 and that takes priority yes? What i gave you will not produce same figures as yours.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,098
Messages
5,466,637
Members
406,493
Latest member
Hazem Hassan

This Week's Hot Topics

Top