Excel formula to Identify the latest date from each order

[maximusben]

Hi all,
I am seeking help with Excel. I have a datasheet with orders that may have multiple dates, and the latest (most recent) date will always be on the first line of each order. On each order number, I need to identify the first line with the latest date with a number 1, and the other lines for that order with a zero. For example, on the table below, I have 2 orders, one with 2 lines, and the other with 4 lines. Order 123456 has the latest date of 7/1/2020, so a number one needs to be shown for this line, and a zero for the other lines. Same logic applies to the other order. My data sheet may have thousands of orders. Please note that the latest date will always be on the first line of each order.Can you please help me with this Excel formula?

Thank you!

Order No	Date Updated	Logic
123456​	7/1/2020​	1​
123456​	5/31/2020​	0​
789012​	7/10/2020​	1​
789012​	1/1/2020​	0​
789012​	10/21/2018​	0​
789012​	5/12/2016​	0​

 

[Eric W]

Welcome to MrExcel!

How about:

Book2
	A	B	C
1	Order No	Date Updated	Logic
2	123456	7/1/2020	1
3	123456	5/31/2020	0
4	789012	7/10/2020	1
5	789012	1/1/2020	0
6	789012	10/21/2018	0
7	789012	5/12/2016	0
Sheet6

Cell Formulas
Range	Formula
C2:C7	C2	=IF(COUNTIF(A$2:A2,A2)=1,1,0)

 

[maximusben]

Thank you so much for your speedy response Eric. Just what I was looking for. I appreciate the help!
Regards,
maximusben