Choosing earliest date customer purchased from us

[DEW67]

Hi,

I have a data table that shows customer number, customer name, month of purchase, date of purchase, purchase amount, etc. For each customer, I'm trying to find the date the client first purchased from us. I have the data in a simple table as well as a pivot table with month along the horizontal axis, customer number on the vertical axis and purchase value in the body of the table. What is the best way to identify the month and year the client first purchased from us.

Thanks in advance

 

[mrshl9898]

You can use MINIFS to find the lowest date. Then =TEXT(Date,"Mmmm") and TEXT(Date,"YYYY") to get the month and year from it.

eg. Customers in column A, Dates in column B and Customer Number in E1.

=MINIFS(C:C,A:A,E1) is the date
=TEXT(MINIFS(C:C,A:A,E1),"Mmmm") is the month
=TEXT(MINIFS(C:C,A:A,E1),"YYYY") is the year

*Assuming your dates are dates and not strings

 

[DEW67]

This is perfect. Thank you