Intial Date Flagged in Excel Database

[Pony08]

I have some products in a table along with a column that has the data entry date (mm/yy). I need a formula that will tell me the first time the product was logged into the table.

Table example:

C618P7 Aug-12
C63036 Sep-14
E80129 Oct-10
C618P7 Oct-14

I need the formula to tell me that Aug-12 was the first time C618P7 was entered into database. Same goes for each item on the list.

Thx

[etaf]

if you want to put all the unique codes into a list and then use
=MIN(IF($A$1:$A$16=$D1,$B$1:$B$16))
where B is the dates
where A is the codes
And D1 is the list
OR

=MIN(IF($A$1:$A$16=$A1,$B$1:$B$16))
and copy down

use control + shift + enter - to get an array formula
{} appear around the formula

[Pony08]

Thx...that worked out great!!!

[etaf]

your welcome , thanks for the rep