max value > show name

[step_one]

Hi

I have two sets of tables (attached sample, where I am trying to extract the max value between two people and then show their name. New to all this, so I apologise for my noob-ness!

I came across the formula:

Please Login or Register  to view this content.

however, it's not working b/c my data of the two people is on the same row (see sample attached).

-I would like for each table (winners and consolation) to show me the winner from each row. i have conditional format to show me the winner, but it would i was hoping a formula can extract the data for me so I dont have to do it manually. (see table in yellow and orange)

Thanks for your time and help with this matter!

[NBVC]

The simplest way would be to enter formula in F54:

=MAX(F17,K17)

copied down

and in D54:

=IF(F17=F54,D17,I17)

similarly in C54:

=IF(F17=F54,C17,H17)

similar logic for the Consolations tables.

[step_one]

Brilliant, didn't see the simplicity that was required! thx you.

[step_one]

One additional inquiry.
I have a validation process for the "bracket" -i.e. select winner after we receive the results etc.

But I've been told to remove that and include a formula. I tried a index(match and it works, however, for instance if the user is i.e. E7 does not exist on the "Results sheet" then it shows N/A...so i tried to implement a "ifstatement" after the match with an array cnt-shift-enter, but getting N/A

Please Login or Register  to view this content.

i have entered that into the playoff sheet in cell F9. your help is truely appreciated.

cheers

[step_one]

I believe, this does the trick

=INDEX('Week 3 - Results'!$D$54:$D$85,MATCH('Playoffs - Winners'!E7,IF('Week 3 - Results'!$D$54:$D$85='Playoffs - Winners'!E11,E7:E11),0))

it seems to get me the correct name? ur thoughts?

[step_one]

new formula:

=INDEX('Week 3 - Results'!$D$54:$D$85,MATCH('Playoffs - Winners'!E40,IF(OR('Week 3 - Results'!$D$54:$D$85='Playoffs - Winners'!E44,'Week 3 - Results'!$D$54:$D$85='Playoffs - Winners'!E40),$E$7:$E$69),0))


actually, same issue, if i remove change the name in the "results" page, then im getting a N/A :S

if u can pls look into the "playoff" worksheet, i have highlighted in red the issue.

for some odd reason, it doesnt like to pick out the names from the two selection, after the very top seeding. thxs for your help (see updated attachment).

[NBVC]

So, you are checking if either of the 2 names in Round 3 exist in the Winners table on the 1st sheet... and if so pull the one with the highest $. Is that correct? If neither exist, then what? Or will that ever happen?

[step_one]

Usually, if its a tie, we look at other factors (manually and select a winner), but generally, using ur method to pick the winners, i would like to use the index(match to auto-populate the winners - so yes you are correct (take the user with the higer $ value) - hence why the table with the max was done earlier.

[NBVC]

Try in F9:

=IF(MATCH(E7,'Week 3 - Results'!$D$54:$D$85,0)<MATCH(E11,'Week 3 - Results'!$D$54:$D$85,0),E7,E11)

this takes the higher of the 2 players from the table.

If it is a tie, it will pull the first one in the table...

You can copy F9 and paste to the other cells in that column and they should adjust.

You will need to adjust the references in the formula for the next tier and the right side of the chart.

[step_one]

that works wonderfully, thx you again.

i had to adjust my data in the winner table (max) so all users were showing up.

quick question, because the list D54:D85 is of the users that have already won (using the max) value; if i dumped or aligned all the users from my original table into that table, based on the matchup in the playoffs page (i.e. david lawdermilk vs. Joseph R.) in the playoff bracket, it will automatically chose the winner that has the highest $, correct?

again, thx you for your explanation and time with this matter. very grateful.

[NBVC]

Basically, it is not picking it up by max, it is just picking the first of the 2 names that it comes across in the table... so if you re-arrange then it will pick the topmost of the 2 in your Round 3 names...

[step_one]

is it possible to have the max included in there?

why i ask bc the data or the ppl in the reference table are already proceeding.

better, i have created a new table (see highlight in red on playoff worksheet).
-if it's possible to have the max() reference into the formula, that would work super.

thxs for your brilliant help! (see updated attachment)

[NBVC]

I am working on something else at the moment and will get back shortly....

[step_one]

much appreciated.

[NBVC]

Does this do it?

=IF(INDEX('Week 3 - Results'!$K$54:$K$117,MATCH(D6,'Week 3 - Results'!$I$54:$I$117,0))>=INDEX('Week 3 - Results'!$K$54:$K$117,MATCH(D8,'Week 3 - Results'!$I$54:$I$117,0)),D6,D8)

[step_one]

You are briliant, genius.

Sincere thanks for your wonderful help!

[dragony2000]

wowowowwowow amazing guys i'm so grateful for you all