I am looking for a formula to calculate the date that a sales person makes the most sales. I have a huge table that looks similar to this:
I want to enter the name I am interested in finding, and it would output the date that the person sold the most. In this example, if I were interested in Frank, it would output 1/7/22 because that is the date that his name appears the most.
Please let me know if this requires further clarification, thanks!
Sale Date | Name |
1/5/22 | Sam |
1/5/22 | Frank |
1/6/22 | Bob |
1/7/22 | Frank |
1/7/22 | Frank |
1/7/22 | Frank |
I want to enter the name I am interested in finding, and it would output the date that the person sold the most. In this example, if I were interested in Frank, it would output 1/7/22 because that is the date that his name appears the most.
Please let me know if this requires further clarification, thanks!