Largest number for team

M

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
 
F

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))
 
M

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.
 
F

Frank Kabel

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top