Here's the issue: I've got three columns of data: Individual, Amount Sold, Date Sold.
People have multiple sales for each given date.
I want to find each person's best night, i.e. all the sales for each given date combined for that date, and then I'd like to see the max for each individual, so I can show them their best night.
I can do this by creating a new sheet with three columns, one containing every date from 1/1/17 to 12/31/17, the next containing the name of a single person, and the third containing a SUMIF formula, so that I have the sum of each person's sales for each day, and then take the MAX from that column. I am sure, however, that there is a better way. A PivotTable seems to only give me the largest single sale from each individual, instead of the night with the largest sale.