Help for excel formula; find duplicate names and then find most recent date

[MSchädler]

Hello there and I require some help to build an excel formula.

Situation: I have a column A with names and a column B with dates.
In my table there are entries with the exact same name, but of those with different entry dates.
I want in column C to identify for each row name duplicates and within these duplicates which one has the most recent date.

The result should give an entry in Column C as =1. All other results should give an entry of = 0.

Can somebody tell me the formula to use in C to achieve this? By the way I have >5000 rows.

Here is my example:

A (Name)	B (Date)	C (most recent entry)
Toronto	12.03.2017	0
Halifax	15.06.2017	0
Toronto	18.05.2017	1
Maxim	01.03.2016	0
Triton	16.06.2017	1
Maxim	05.03.2017	1
Halifax	20.08.2017	1
Toronto	15.04.2017	0

<tbody>
</tbody>

Thank you for the help.
M.

 

[Eric W]

Try this in C1 and drag down.

=IF(COUNTIFS(A:A,A1,B:B,"<="&B1)=COUNTIF(A:A,A1),1,0)

If you have headers, put it in C2, and change A1 and B1 to A2 and B2.

 

[MSchädler]

Hello Eric

Many thanks for your help and for the formula. Your inputs with a bit of adaptation works wonderful.
You saved my day!!!

Regards, M.

 

[Eric W]

Glad it works for you!