Hiya folks.. I'm trying to figure out an excel only solution to duplicate an access query.

I have a datasource with multiple entries for a given item number. These entries have a date and a quantity attached to them. I want to return the date and quantity for the most recent entry ONLY.

In access I accomplish this like so:

Code:
SELECT SAFETY_STOCK.Item, _STOCK.[Effective Date], SAFETY_STOCK.UOM, SAFETY_STOCK.Quantity
FROM SAFETY_STOCK
WHERE (((SAFETY_STOCK.[Effective Date])=DMax("[Effective Date]","SAFETY_STOCK","Item = '" & [Item] & "'")))
ORDER BY SAFETY_STOCK.Item;
How can I duplicate this behavior in excel and produce a worksheet containing only the records with the most recent "effective date" for a given part?