Quick question about Formulas with TEXT

[lord worm]

Hi,

Ive got a spreadsheet that keeps track of wins and losses for my
wrestling video game.
I want to add a column that adds all the wins, and then displays the Name of the person with the most wins. all i know how to do is have it show the Number of wins but not the name.

Is it a matter of Labeling or Designating the cell??

Thanks in advance

[NBVC]

Can you show a sample of how your data is setup and some expected results?

[lord worm]

Looking at the Attached picture.
Step 1 = was to add the title totals, which i did with the SUM function, adding cells B3 thru H3
Step 2 = I used the MAX function to locate the wrestler with the most Total titles, which is displayed as a number in K3
In column K3 i'd like for a formula to Show the name associated with column A in text in Cell K2

I suggest you ignore the Rows for Defences, cause its the same formula to add those as well.

Can it be done?

[NBVC]

Assuming based on your totals in Column I:

Try:

=INDEX(A2:I9,MATCH(MAX(I2:I9),I2:I9,0)-1,1)

adjust the ranges, though, to ensure you capture the whole table.


BTW: Is this professional wrestling.....isn't Eddie Guerrero passed away?

[lord worm]

That worked!
I greatly appreciate your help.
I've tried other boards and got little help.

Is it possible to break down the formula for me?
that way I can fully understand what is taking place?

Thanks again.

Its a wrestling Video Game.

[NBVC]

The INDEX() function Syntax is...INDEX(array,row_num,[column_num])

and the MATCH() syntax is ...MATCH(lookup_value,lookup_array,[match_type])

The Index finds the interception point within the array (which is a table) of the row and column numbers of interest.

The Match() function gives the position within the lookup_array that the lookup_value is found...which is translated to the row_num within the Indexed array.

So Match(Max(I2:I9),I2:I9,0) finds the vertical position within array I2:I9 of the max value in that same array.... the 0 tells Match to find exact match.

The -1 after the match simply says to get the row previous to the actual matching row...so basically offset by -1 row.

The optional 1 in the last argument of the Index function says to look in column 1 of the indexed array. If it was a one-column array, you could leave this out.

Hope that helps!

See those functions in Excel help for more detail and samples