Ben_Holmes
Board Regular
- Joined
- Mar 30, 2004
- Messages
- 147
Hi,
I am looking of a quick way of finding the minimum date (start date) amongst a large data set for each customer.
Each customer has access to a number of products. I have a list of data customer and product that details the start date which a customer started using a particular product. I want to produce a list of customers that details the earliest date, i.e. the date which they started using our services.
Date is as follows:
Customer name Product Code Start Date
A AA1 10/10/10
A BB1 12/12/10
B AA1 09/09/10
C AA1 10/10/11
etc.
I have 30,000 rows of data containing 6,000 customers accessing 35 different products.
Any help would be apprciated.
I have tried using a vlookup however this pulls the first date it comes across and not the earliest date. What I need is a vlookup minimum finder.
Kind Regards
Ben
I am looking of a quick way of finding the minimum date (start date) amongst a large data set for each customer.
Each customer has access to a number of products. I have a list of data customer and product that details the start date which a customer started using a particular product. I want to produce a list of customers that details the earliest date, i.e. the date which they started using our services.
Date is as follows:
Customer name Product Code Start Date
A AA1 10/10/10
A BB1 12/12/10
B AA1 09/09/10
C AA1 10/10/11
etc.
I have 30,000 rows of data containing 6,000 customers accessing 35 different products.
Any help would be apprciated.
I have tried using a vlookup however this pulls the first date it comes across and not the earliest date. What I need is a vlookup minimum finder.
Kind Regards
Ben