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?
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?
Last edited by rainbow_1985; 06-18-2009 at 06:24 PM.
Try
=Index(Name_Range,Match(Max(Points_Range),Points_Range,0))
Replace respectively named ranges with actual ranges....
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
It becomes easier to help u if u post some examle...
Люди, питающие благие намерения, как раз и становятся чудовищами.
Regards, ?Born in USSR?
Vusal M Dadashev
Baku, Azerbaijan
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?
=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...
thank you very much!
I get error for this one:
=Index(B2:B30,Match(Max(I2:I30),I2:I30,0))
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...
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
IT WORKED! thank you
=INDEX(B2:B30;PASSA(MAX(I2:I30);I2:I30;0))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks