title: How to rank within category in Excel?
body: <p>I have a list of customers by region with sales value. I want to create an overall ranking of all customers by sales values as well as the ranking of customers by sales value within the region and use both the ranking to calculate a score. is there a way to do this in Excel?</p>
  
  <p>Either formulae or VBA code would be helpful for me. </p>