I have a table with dates in the horizontal axis and names in vertical. I need a function that would give me both the name of the top salesperson for a week ending in a selected date and their sales for that period.
For example, for the same information by day I used these 2 equations...