Finding text

[rainbow_1985]

So I've got a table that contains a list of players and a bunch of columns that give information about the number of matches, points,...

How do I find out the name of the player that has maximum points with a formula?

[NBVC]

Try

=Index(Name_Range,Match(Max(Points_Range),Points_Range,0))

Replace respectively named ranges with actual ranges....

[contaminated]

It becomes easier to help u if u post some examle...

[rainbow_1985]

ok here's a pic. (attached) The questions I need to answer are:

a. who has the highest score in poäng/match and how many points is it?
b. who has the lowest score in poäng/match and how many points is it?
c. which player has the highest point in utvisningsminuter and how many points is it?
d. which player has the lowest point in utvisningsminuter and how many points is it?

e.which players have the highest/lowest points in utvisningsminuter/match?

[NBVC]

=Max(Points_Range) finds maximumg

=Min(Points_Range) finds minimums


=Index(Name_Range,Match(Max(Points_Range),Points_Range,0)) finds name associated with Max


=Index(Name_Range,Match(Min(Points_Range),Points_Range,0)) finds name associated with Min

Replace N_Range with $B$2:$B$30 and Points_Range with $H$2:$H$30 for poäng/match

and similarly for other ranges...

[rainbow_1985]

thank you very much!

[rainbow_1985]

I get error for this one:

=Index(B2:B30,Match(Max(I2:I30),I2:I30,0))

[DonkeyOte]

It will no doubt be a case of "lost in translation" ... NBVC's examples are based on English language and with , as delimiter... yours will invariably be ; as delimiter and you may also need to translate the functions into Swedish equivalents... there is a link to to a Function translator in my signature.

Failing that post an actual file, XL will auto translate to appropriate language etc based on client - we can then post back a working version which will similarly revert back according to your own client settings when you re-open...

[rainbow_1985]

IT WORKED! thank you

=INDEX(B2:B30;PASSA(MAX(I2:I30);I2:I30;0))