To find first shipping of a part code in a table

[Ongbey]

In an excel data table; there are 'Part Codes' in column A (alphanumeric) and 'Shipping Date' dates in column B. Since many codes in the table are sent many times, there is a lot of Shipping Date data for the same code. What I want is to write the 'First Shipping Date' value of the product in that row to the C column. Note that table consist of 20.000 rows.

 

[Fluff]

How about

=IF(COUNTIFS(A$2:A2,A2)=1,B2,"")

 

[Cubist]

Is the Shipping Date in the actual data sorted?

 

[Ongbey]

How about

=IF(COUNTIFS(A$2:A2,A2)=1,B2,"")

This formula create error as '#AD?'. My data is alphanumeric as shown. May be it is reason of error.

 

[Ongbey]

Is the Shipping Date in the actual data sorted?

Shipping date is not sorted

 

[MARK858]

What language is your excel in?

 

[Ongbey]

What language is your excel in?

What language is your excel in?

Yes, you are right, code worked. I changed the formula to my language.

 

[Ongbey]

How about

=IF(COUNTIFS(A$2:A2,A2)=1,B2,"")

Thanks

 

[Fluff]

Glad we could help & thanks for the feedback.