How to find 1st instance, 2nd Instance for a unique ID based on date

[Kiatsu]

I have the following table sample. I need to indicate in the Shipment column,the first time something with the unique ID , the 2nd.. etc. it has to be based on date and not location in the sheet. And if the ID does not repeat then it is the 1st shipment.

ID	Ship Date	Repeat	Shipment
AST897P	10/4/2017	No	1st
AST1087	11/7/2017	Yes	1st
AST1087	11/23/2017	Yes
GRP911	12/10/2017	No
GRP795	10/27/2017	No
BHY902	10/27/2017	Yes	2nd
BHY902	11/22/2017	Yes	3rd
BHY902	9/25/2017	Yes	1st
GYT214	9/25/2017	No

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

 

[VBA Geek]

try:

<b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">D2</th><td style="text-align:left">=COUNTIFS(<font color="Blue">A$2:A$10,A2,B$2:B$10,"<"&$B2</font>)+1</td></tr></tbody></table></td></tr></table><br />

Excel 2013/2016
	A	B	C	D
1	ID	Ship Date	Repeat	Shipment
2	AST897P	10/4/2017	No	1
3	AST1087	11/7/2017	Yes	1
4	AST1087	11/23/2017	Yes	2
5	GRP911	12/10/2017	No	1
6	GRP795	10/27/2017	No	1
7	BHY902	10/27/2017	Yes	2
8	BHY902	11/22/2017	Yes	3
9	BHY902	9/25/2017	Yes	1
10	GYT214	9/25/2017	No	1
Sheet1

 

[wideboydixon]

Use SUMPRODUCT like this:

Book1
	A	B	C	D
1	ID	Ship Date	Repeat	Shipment
2	AST897P	10/4/2017	No	1
3	AST1087	11/7/2017	Yes	1
4	AST1087	11/23/2017	Yes	2
5	GRP911	12/10/2017	No	1
6	GRP795	10/27/2017	No	1
7	BHY902	10/27/2017	Yes	2
8	BHY902	11/22/2017	Yes	3
9	BHY902	9/25/2017	Yes	1
10	GYT214	9/25/2017	No	1
Sheet2

Cell Formulas
Range	Formula
D2	=1+SUMPRODUCT(($A$2:$A$10=$A2)*($B$2:$B$10<$B2))

WBD

 

[Kiatsu]

This worked great thank you

 

[Kiatsu]

This worked really well. Thank you