Hi there,
I am trying to find a formula that will allow me to return the Salesperson that has sold the most Units in 1 month.
I know ways to do it by creating a second table to sum the amounts, but I want one cell that simply shows the Salesperson's name.
The data is set out by DATE, UNITS SOLD, REVENUE, SALES PERSON.
The date is entered as MM/DD/YYYY.
Screen Shot 2016-05-16 at 3.31.05 PM.png
Bookmarks