Return Newest Date

[tiger01]

Hi
I have a table (approx 30,000 rows) which has several columns. Column A is a Unique = country & ID e.g. UK_123, then next to this I have a date column. I have have multiple different dates associated with each unique and so I need a formula to look up all dates associated with that unique and return or indicate the newest date i.e. newest date = "1" and every other date = "0". Can anyone help me please?

Thanks

Jen

[Ace_XL]

With your date in Column B use in Row 1

=--(B1=MAX(INDEX(($A$1:$A$30000=A1)*$B$1:$B$30000,0)))

Copy down..adjust ranges accordingly

[tiger01]

Thanks, it worked a treat!

Could I ask if you could explain the formula to me please,for example, what does the "--" at the beginning do?
Cheers

Jen

[Ace_XL]

The -- only converts the result (TRUE or FALSE) to binary form

TRUE is 1 and FALSE is 0.