How to pick the most successful team?

[natasa.sos]

I have an exercise where there are different teams selling different kinds of books. I made most of the tasks, but I am stuck with the last ones where they ask me to "In columns D to H in rows 45 & 46 indicate which team had the highest/ lowest figures."
I don' know hot to do this. We only learnt IF, MAX, MIN, OR functions, and I tried to make function using IF and MAX but it didn't work.
Could you please help me?

[zbor]

You can find MAX value as: MAX(G11,G19,G27,G35,G43)

Now you need to check each value is same as that max value.
If yes, that is your team.

For first user it would be:

Please Login or Register  to view this content.

So if G11 is same as MAX value then answer is in B4.
If not check next as:

Please Login or Register  to view this content.

Etc.


When you use all options you will get:

Please Login or Register  to view this content.

You can see that last value if IF function is FALSE is omitted.
That's because one of those criteria must return value because at least one of them is max value.

[zbor]

Use similliar for MIN.

Note that this is not shortest solution but it's made by only IF and MAX functions.

[samba_ravi]

see the attached file