take the last occurence

Is there an equivalent to the access fonction last fonction in Access?


For exemple,
I'm trying to retrieve the ending inventory that was produced ("Prodn") in my spreadsheet attached.

For instance, my 1109-08 product, I'm looking to retrieve the 11,243.00 figure that was produced this week.(and I know my raw data is awfull, it's an extract of a fugly UNIX based software, so my 11243 show on page 3 of that report).


Does anyone know what type of function best suits this?