I need a formula to rank from 1-13 highest 1 lowest 13. The real spreadsheet is way to complex to sort. I need to base regions in sales volume and amount sold. Since the formula would be the same no matter what the criteria is, a solution to the attached spreadsheet is all I need and I can figure out the rest. I attached a spread sheet which will explain basically what I'm trying to do. I've been doing this manually but it's taking me so much time and I'm starting to make mistakes because of the number of catagories I need to compute.
Bookmarks