Finding the lowest date in of a particular year

[maria90]

I've got two table ranges: CustomerID and Date. I'd like to find out the lowest date of a particular customer and year.
Example:

CustomerID	Date
1	13.02.2014
2	03.04.2014
1	08.08.2014
1	01.12.2014
1	01.01.2015
6	01.02.2015
7	01.03.2015
8	01.04.2015

<tbody>
</tbody>

I tried to use SUMPRODUCT to find the lowest date for customer 1.
=SUMPRODUCT((Orders[CustomerID]=1)*(Year(Orders[Date]=2014)*(MIN(Orders[Date]))


Now this doesn't work. I tried (array) IF formulas, but they don't seem to work either.
What would you do in order to find the lowest date/the first order of a customer?

Thanks
Maria

 

[shg]

One way:

Row\Col	A​	B​	C​	D​	E​
1​	ID​	Date​
2​	1​	13 Feb 2014​
3​	2​	03 Apr 2014​
4​	1​	08 Aug 2014​
5​	1​	01 Dec 2014​
6​	1​	01 Jan 2015​
7​	6​	01 Feb 2015​
8​	7​	01 Mar 2015​
9​	8​	01 Apr 2015​
10​
11​	ID​	2014​	2015​
12​	1​	13 Feb 2014​	01 Jan 2015​		B12: {=IFERROR(1 / (1/MIN(IF(($A$2:$A$9 = $A12) * (YEAR($B$2:$B$9) = B$11), $B$2:$B$9))), "")}
13​	2​	03 Apr 2014​
14​	6​		01 Feb 2015​
15​	7​		01 Mar 2015​
16​	8​		01 Apr 2015​

 

[maria90]

Excellent! That's what I was looking for.
Thanks
Maria

 

[shg]

You're welcome.