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.

[TABLE="width: 411"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]ID[/TD]
[TD]Ship Date [/TD]
[TD]Repeat[/TD]
[TD]Shipment[/TD]
[/TR]
[TR]
[TD]AST897P[/TD]
[TD="align: right"]10/4/2017[/TD]
[TD]No[/TD]
[TD]1st[/TD]
[/TR]
[TR]
[TD]AST1087[/TD]
[TD="align: right"]11/7/2017[/TD]
[TD]Yes[/TD]
[TD]1st[/TD]
[/TR]
[TR]
[TD]AST1087[/TD]
[TD="align: right"]11/23/2017[/TD]
[TD]Yes [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]GRP911[/TD]
[TD="align: right"]12/10/2017[/TD]
[TD]No[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]GRP795[/TD]
[TD="align: right"]10/27/2017[/TD]
[TD]No[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]BHY902[/TD]
[TD="align: right"]10/27/2017[/TD]
[TD]Yes[/TD]
[TD]2nd[/TD]
[/TR]
[TR]
[TD]BHY902[/TD]
[TD="align: right"]11/22/2017[/TD]
[TD]Yes[/TD]
[TD]3rd[/TD]
[/TR]
[TR]
[TD]BHY902[/TD]
[TD="align: right"]9/25/2017[/TD]
[TD]Yes[/TD]
[TD] 1st[/TD]
[/TR]
[TR]
[TD]GYT214[/TD]
[TD="align: right"]9/25/2017[/TD]
[TD]No[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

 

[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