Returning most recent daily data in a column if blanks in column

First time user.....(already posted in access by mistake!)

I know this is probably easy to most users of this forum but could someone explain how I return the most recent days data in a column if there are spaces in the column and the figures I need only appear at every subtotal row? There can be anything from 5 to 20 rows for each subtotal.

I have attached a sample worksheet. I want to return in H3 & I3 the most recent date %figure for each column

If more info need please let me know

Thanks

Innes