Largest number for team

[McG]

Sorry I do not know how achieve my objective. I created a league table
for the total number goal scored over the season using the SUMIF
function. My problem is I want to now the maximum goals scored in the
highest scoring game.
There are 20 in total.
There are 10 matches for every Games number.
There are 38 games per team (19 home and 19 away)
Hence the 380 rows

E3:E382 are the home teams F3:F382 are the home scores.
G3:G382 are the away teams H3:H382 are the away scores.

So the sheet looks like this
Col E Col F Col G Col H Games
Team 2 3 Team 7 1 1
Team 9 0 Team 4 1 1
¦
¦
¦
Team 4 0 Team 5

Thanks Mcg

 

[Frank Kabel]

Hi
for the maximum Home score use something like the following array
formula (entered with CTRL+SHIFT+ENTER):
=MAX(IF(E3:E382="Team 2",F3:F382))

 

[McG]

Hi
for the maximum Home score use something like the following array
formula (entered with CTRL+SHIFT+ENTER):
=MAX(IF(E3:E382="Team 2",F3:F382))

Doh I tried =IF(MAX(E3:E382="Team 2",F3:F382)) but it did not work.

 

[Frank Kabel]

Hi
have you entered this formula as array formula with CTRL+SHIFT+ENTER.
If yes what wrong result did you get?

 

[McG]

Hi
have you entered this formula as array formula with CTRL+SHIFT+ENTER.
If yes what wrong result did you get?

Frank,
Your formula was correct but I was trying different functions
to acheive what my original problem prior to posting the original
message.
Thank you once again