Get the Date of First Transaction
I have a table with the following data points:
- Date
- Gallons
- Customer Name
I would like to somehow be able to automatically pull the FIRST TRANSACTION DATE of a customer.
For Example:
Billy's Gas Station [Customer Name] | March 25, 2013 [Date of First transaction or first entry]
Doug's Truck Stop [Customer Name] | March 11, 2013 [Date of First transaction or first entry]
Any idea on how to do this if I only have the data of the table up top?
Thanks!