'Excel SUMPRODUCT to rank , duplicating same rank for the product
I have a list of products that are sold in different regions. To find top opportunity though, I need to look at the National level. I am trying to rank product using sumproduct with countif but not getting desired result.
I have used following formula
ROUND(SUMPRODUCT((E3<$E$3:$E$11)/COUNTIF($B$3:$B$11,B3))+1,0)
Please help how can I achieve the required result
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
Solution | Source |
---|