Find the Minimum Date for rows with same customer Id

Hi,

I have a column of CustomerIds and a column of ClickDates. The CustomerIds may appear more than once. The ClickDate for a customerId may be the same date or it may be different. What I need to do is create another column which contains ONLY the earliest ClickDate for the associated CustomerId.

The actual file has over 3,000 rows.

CustomerId Click_Date EarliestClickDate
7321391 10/24/2008
7321391 10/1/2008
7321402 11/3/2008
7321402 10/3/2008
7321402 11/3/2008
7321402 9/27/2008
7321506 12/18/2008
7321506 1/27/2009

The successful formula will yield this:

CustomerId Click_Date EarliestClickDate
7321391 10/24/2008 10/1/2008
7321391 10/1/2008 10/1/2008
7321402 11/3/2008 9/27/2008
7321402 10/3/2008 9/27/2008
7321402 11/3/2008 9/27/2008
7321402 9/27/2008 9/27/2008
7321506 12/18/2008 12/18/2008
7321506 1/27/2009 12/18/2008

Thanks,

Jason

Originally Posted by sweep

Hi,

This array formula will do it for you I think

Assuming your current data is A1:B8, this in C1 and copied down

=MIN(IF($A$1:$A$8=A1,$B$1:$B$8,""))

Confirm with CTRL, SHIFT and ENTER,

That did it! Thank you!

Jason