"MAXIF" formula?

[freud1]

Hi Guys,

Example attached.

I have a grid of data

Column A - D365 days
Row 1 - Half hourly times for the day (columns B - AW)

On sheet 2 I am looking for a formla which whill Return the MAXIMUM Value which occurs for each month.

I was hoping to find some kind of MAXIF formula but I don't think one exists.

Thanks for your help

F

[zbor]

Try pivot table:

[daddylonglegs]

There's no MAXIF function but you can get the result using an "array formula" like this

=MAX(IF(TEXT(Data!A$2:A$500,"ddd-yy")=TEXT(A2,"ddd-yy"),Data!B$2:AW$500))

see attached

[freud1]

Zbor, Daddylonglegs,

Both solutions work fantastically!

many thanks for your help!