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

If there's only one subtotal row per day, how about:

=IF(H2=MAX($A:$A),INDEX($A:$I,MATCH("Grand Total",$A:$A,0)-1,COLUMN()),INDEX($A:$I,MATCH(H2+1,$A:$A,0)-1,COLUMN()))

Hello,

Great thanks. It works on my example worksheet but can't get it to work in the worksheet I am using but I'll crack on with it and try a few things. Thanks for your help

Hello again,

I've tried it but still not working. If I send you my actual worksheet could you have a look at the reference I've adapted from yours (it's in cell P3 now).

Thanks again, much appreciated.

Didn't account for there being spaces before the Grand Total line.

However, I also didn't notice the subtotal lines said Total at the end in col A. So this can be simplified to:

=INDEX($A:$R,MATCH(TEXT(P2,"dd/mm/yyyy")&" Total",B:B,0),COLUMN())

Lovely, works now. Thanks again