Formula to enter highest number from a range of cells

Hi all

I have attached an excel sheet with an explanation on what type of formula I am looking for. This information should complete my chart I have been putting together, so there shouldnt be lots more questions from me as I have bombarded the forums the last few days lol.

Thanks
Gemma

Assuming you want the formula in cell D7 you can use this:

=MAX(AG2:AG982*((U2:U982=$A$1)*(X2:X982=D$1)*(Y2:Y982=$A7)))

It is an array formula so it has to be entered with Ctrl + Shift + Enter

I have not used the full ranges because you have #N/A errors beyond the range I used. You will have to get rid of those before you can use the full ranges in the formula otherwise your result will also be #N/A.

EDIT - sorry - forgot to absolute reference

=MAX($AG$2:$AG$982*(($U$2:$U$982=$A$1)*($X$2:$X$982=D$1)*($Y$2:$Y$982=$A7)))

Hi,

No formulas needed. Just create a Pivot showing Max instead of Sum or Count.
See attached.

Good Luck at the Races.