"Victor Delta" wrote in message
...
"Infinitogool" wrote in message
...
Hi Victor

you could try this, array-entered, E1:
dates: A1:B100
=MAX(($A$1:$A$100=D1)*$B$1:$B$100)

Copy down as far as needed

Very many thanks to both of you.

Biff - I have used your formula and it works perfectly. I also used
conditional formatting to hide the unwanted zeros.

V

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP