• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Max with Restrictions Dividing Two Columns

Pedro

New Member
Hi all,

I am having a hard time to get the result either by formula or macro. Hope someone can help:

I need to find the MAX value of the Sales per Store (diving one column by other column) under the following restrictions:
  1. only for the month 12 (referenced cell)
  2. only for years greater than 2016.
  3. for the respective projected periods ahead (M1, M2, etc)
Thanks!
 

Attachments

  • Sample.xlsx
    11.9 KB · Views: 4
Back
Top