Small If on Range

[Confidentjohn]

Hi

I need to figure out the first date a customer ordered an item, i have a very large database output and with customer ID and Order dates, against each customer I need add a cell that states the 1st order date.

Raw data example
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Customer ID[/TD]
[TD]Order Date[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1/10/2012[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]25/12/2012[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1/1/2013[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1/11/2012[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1/12/2012[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1/1/2013[/TD]
[/TR]
</tbody>[/TABLE]

Next to each line i want to add the earliest order date, is there a way using if and small against a range to do this?

Any help will be greatly appreciated.

John

 

[MFitz10]

Array Formula (CTRL + SHIFT + ENTER)
=MIN(IF($A$2:$A$7=D1,$B$2:$B$7,""))

D1 = Customer ID

 

[Scott Huish]

=MIN(IF(A:A=A2,B:B))

Confirm with CTRL-SHIFT-ENTER rather than just Enter.

Excel Workbook
	A	B	C	D
1	Customer ID	Order Date		Min Order Date
2	2	1/10/2012		1/10/2012
3	2	12/25/2012		1/10/2012
4	2	1/1/2013		1/10/2012
5	3	1/11/2012		1/11/2012
6	3	1/12/2012		1/11/2012
7	3	1/1/2013		1/11/2012
Sheet1

 

[Confidentjohn]

Perfect, Thank you both for your help, this worked perfectly, even if it did take about 4 hours to process on my ropey laptop and slightly large file.

Cheers

John