Matching Value in F:F to lastest date/time in A:A

The suggested formula is an Array so must be confirmed with CTRL + SHIFT + ENTER (not just Enter) - once Array is set the formula will appear encased within { }

IMHO Pivot Tables should be the very first thing anyone learns when using XL.
PTs are so simple it's untrue and offer unprecedented reporting power at the click of a few buttons... with the introduction of PowerPivot with XL2010 I think they look set to take over the world!

I should have realized the Ctrl+Shift+Enter from

You can use a MAX array

. I must have had a brain fart! Thanks for the replies. I've been wanting to learn more about PT's but fell in love with Excel's formulas. I'll try to make time to do some reading/practicing.

Thanks