Finding Max Occurance Based on Criteria

Find Max Occurance.xlsx

This workbook has a table that contains a date column, Sales person column, customer column, sales amount column and item sold column.

On Sheet 1 I would like to select a sales person and a customer and return a max sale that that sales person made to that customer, the date it occurred and the item that was sold.

In addition to that I would like to return the max sale that sales person has ever made, regardless of who the customer was, the date it occurred and the item sold. How would I accomplish this?

Thank you, it worked!