Hi,

This is a bit complicated. I have downloaded a bunch of data on French power plant availability, see http://clients.rte-france.com/servle...let?annee=2012

This is in Excel format and shows forecast power plant availability for each day, by fuel type.
Column A shows the Day which the forecast applies to.
Column B shows a series of days for which the forecast was made for the date in column A.
What I want to find is, for each day in column A, what the last forecast was - ie the closest to real-time.
So basically I want to do a maxif on column B, for each day in the year.

I could do it in VBA, but that seems like overkill, it would be much more convenient to do in a formula.

Any ideas?

Tracy