Forum Discussion
Determining New Rank/Order to Maximize Sales
I have a data set from a website that lists items in Category Order. Using the Product Views, Click-thru Rate, Sales, and Sales/Views% I need to re-order the Category Order that will maximize Product...
bfishy81 You can do this using a RANK.EQ function. However, in order to deal with duplicate ranks, you need to combine it with a COUNTIF function containing an expanding reference. I made a custom video showing how to build and implement this formula in your case: https://www.youtube.com/watch?v=D3_p4ZLNuSs
=RANK.EQ(C2,$C$2:$C$56)+COUNTIF($C$2:C2,C2)-1
Optional tip if this was helpful: [link removed by admin]