How to find Duplicates Cluster with Latest Date ?

Hello Everyone,

I was Stuck where I have three col like Cluster, Dates, Numbers.

How to find Duplicates cluster which are having latest date and I want Fourth additional col which shows "TRUE" for Latest date and "FALSE" for other having old dates.

Is there any Macro or Query to find please share ?

Example:

Example.jpg

Example:

Data like :

62---3/5/2008---1
62---9/3/2009---2
49---1/21/2000---3
49---1/1/2010---4
62---1/11/2000---5
49---3/1/2001---6
287---3/23/2009---7
287---12/2/2010---8

Want OUTPUT like below:

62__3/5/2008__1__FALSE
62__9/3/2009__2__TRUE
49__1/21/2000__3__FALSE
49__1/1/2010__4__FALSE
62__1/11/2000__5__FALSE
49__3/1/2001__6__TRUE
287__3/23/2009__7__FALSE
287__12/2/2010__8__TRUE

Need Help :-)

Thanks

Hi Swapnil121mali,
you can find solution you asked for in attachment. Be carefull with definition formula in E column, you have to declare every particular cell in E column as array (with ctrl shift enter). Not all cells together, but cell by cell.

Best regards,

by the way, you have output error in your example considering cluster 49...

In file attached from mnjofra, in E4:
=C4=MAX(INDEX(($B$4:$B$11=B4)*$C$4:$C$11,))
just enter