Find smallest date based on the condition of another cell

[fileninja]

I have a table with customer orders which are dated and index by customer id:

customer1, 1/1/2002, etc...
customer2, 1/1/2003, etc...
customer2, 1/1/2004, etc...
customer1, 1/1/2005, etc...

I want to find the date of the first and last order a customer made with me. The end report I want is:

Name, First Order, Last Order
customer1, 1/1/2002, 1/1/2005
customer2, 1/1/2003, 1/1/2004

I already have a unique list of the customers for the report, I need the formula for 'First Order' which is likely almost the same as 'Last Order'.

I've been working on different reports all day and this site is invaluable. Thanks kindly.

 

[Aladin Akyurek]

Control+shift+enter, not just enter:

=MIN(IF(CustomerRange=Customer,DateRange))

=MAX(IF(CustomerRange=Customer,DateRange))

Or with some control:

=IF(ISNUMBER(MATCH(Customer,CustomerRange,0)),MIN(IF(CustomerRange=Customer,DateRange)),"Not Available")

 

[fileninja]

Works like a charm. Thanks for the quick response.

Cheers