I would like to return the max value of a product within a given date range. Would this be done with a max/index match formula? I'm not sure how to approach it.
Then, once this max value is established, return the name of the person who achieved this result.
See the attached spreadsheet.
Thanks for your help