Hello All,
First off, I want to thank you in advance for your assistance. I am trying to create a formulaic (non-macro) way to tabulate an Average Unit Rate (AUR). I have attempted to build several layers of formulas to calculate this, but have been unsuccessful so far. In the attached document, my inputs are highlighted in green and what I'm trying to solve for is highlighted in blue. For this example, I am trying to calculate the AUR for Zone #2 in 2Q15. If you look off to the right, I have performed a manual calculation of what the AUR should be ($607). Now when you look at my formulaic method (cell R20, highlighted in yellow), you'll see that it's returning $871. However, when you look at the corresponding possible unit rates in the table (F12-F16) you'll see there is nothing higher than $725, making $871 mathematically impossible.
Again, I thank you in advance for your assistance in helping me to formulaic-ally automate this process.
Bookmarks