I have an Excel sheet that looks like this:
Event City | Sale Date Los Angeles | 6/19/18 Los Angeles | 6/25/18 Los Angeles | 6/29/18 Phoenix | 6/20/18 Phoenix | 6/27/18 Phoenix | 7/14/18
I need to figure out how to return, using a formula, the earliest Sale Date using the Event City.
For instance, using a formula I need to be able to specify "Los Angeles" and have it return "6/18/18".
I'm not even sure where to begin. Any help would be greatly appreciated!