getting name value in cell from If formula

G

Guest

i have a fairly simple spread sheed used to tally score results. column A for
participant name, b for beginning score c for ending score d for the total
and e is where I'd like the name of the winner to be placed.
For example:
row 1: Mary, 500,600, 100
row 2: Susan, 500, 700, 200
in columm E I would like susan's name to appear as the winner.
I am not very familiar w/ formulas, if anyone can tell me what I need to put
in that cell to accomplish this I would be very grateful.
Thank you,
 
B

Biff

Hi!

Assume the data range is A1:D10

Enter this formula in E1:

=INDEX(A1:A10,MATCH(MAX(D1:D10),D1:D10,0))

Can there be more than 1 person with the winning score?

Biff
 
G

Guest

hi Biff
this sort of works, but i think I need to give more info yet.

Let's say i have 8 participants, each name would be entered in colum A,
their start score in Colum B, their End score in Column C and the total In
Column D

row 2 & 3 are competing against eachother, row 4 & 5 are competing against
each other and row 6 & 7 are against eachother. I want the Winner between 2
& 3; 4 & 5; 6 & 7 to be entered into Column E only based on the score in
Column D.

So i guess i'm needing a formula that will look at the two rows and enter in
the winner for each pair.

Thanks,
Nichole
 
B

Biff

Hi!
row 2 & 3 are competing against each other, row 4 & 5 are competing against
each other and row 6 & 7 are against eachother. I want the Winner between
2
& 3; 4 & 5; 6 & 7 to be entered into Column E only based on the score in
Column D.
Click to expand...

What you should do is separate each pair of competitors so you'll know at a
glance who is competeing against who. With all the data in a contiguous
block it's hard to distinguish the pairs. (and a lot more difficult to come
up with a single formula that'll do what you want)

A1 Name
A2
A3 Tom
A4 Bob
A5
A6 Lisa
A7 Sue
A8
A9 Eric
A10 Bo
etc
etc

Enter this formula in E3 and copy down as needed:

=IF(D3="","",IF(AND(D4="",D3<D2),"",IF(D3>D4,A3,"")))

Biff
 
G

Guest

Biff, I can't thank you enough. This formula worked like a dream! EXACTLY
what I wanted.
Thanks so much!!
Nichole
 
B

Biff

You're welcome! Thanks for the feedback.

Biff

Nichole said:
Biff, I can't thank you enough. This formula worked like a dream! EXACTLY
what I wanted.
Thanks so much!!
Nichole
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function or Formula to show the value from above cell 8
Lookup a name if cell value first letter is in a range 1
underscore between name in excel csv format to export names into o 3
Look up and match Vendor name in one cell of worksheet from list ofmultiple Vendor names in column o 2
getting column and row names if a cell has a value 4
Help with macro to populate blank values 2
Conditional formatting in a cell formula 1
VBA Code to Use "Name" in a cell as a reference 1

Top