A B C D E F G
CAR NO. RUN 1 RUN 2 RUN 3 TOTAL QUALIFIER
5 6 4 3 13
CAR NO 2
2 4 6 7 17
This is a qualifying sheet we are making up for a motorsport event we run, in the knockout rounds two cars go head to head over three runs, the car with the highest score after the three runs progresses to the next round. In column B we input the car numbers, in columns C. D. and E we input their scores, column F is an autosum of C.D.E. in column G. I want to show the winning cars number, not its score, anyone got any ideas? Thanks in advance,
Kieran.
PS. this is part of a larger spreadsheet with which I've recieved much help from this forum, I can make this available if anyone's intrested, if I can figure out how to post it on this forum, The spreadsheet is for DRIFTING and it automatically picks the top 16, sets up the knockouts, final 16, final 8, final 4, final 2, and the winner.
(The grid I did above went daft when I posted it, I did another on the attachment.)

Hi , one way ..

Assume the table below is in B1:G4,
where the result under "Qualifier" is to appear in G3

CAR NO._RUN1_RUN2_RUN3_TOTAL_QUALIFIER
__5______6____4____3_____13
______________________________ Car# 2
__2______4____6____7_____17

In F2 and F4 are the formulas: =SUM(C2:E2), =SUM(C4:E4)
which compute the Total scores from runs 1 to 3

Put in G3:
=IF(OR(F2=0,F4=0),"",IF(F2=F4,"Dead Heat - Re-run?","Car#
"&INDEX(B2:B4,MATCH(MAX(F2:F4),F2:F4,0))))

G3 will return the desired result

If the total scores are tied,
G3 will return the phrase: Dead Heat - Re-run?
(just a suggested return, as you didn't say what should happen
in the event of ties)

Adapt to suit ..
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"kiki" wrote in message
...

A B C D E F
G
CAR NO. RUN 1 RUN 2 RUN 3 TOTAL
QUALIFIER
5 6 4 3 13

CAR NO 2
2 4 6 7 17
This is a qualifying sheet we are making up for a motorsport event we
run, in the knockout rounds two cars go head to head over three runs,
the car with the highest score after the three runs progresses to the
next round. In column B we input the car numbers, in columns C. D. and
E we input their scores, column F is an autosum of C.D.E. in column G.
I want to show the winning cars number, not its score, anyone got any
ideas? Thanks in advance,
Kieran.
PS. this is part of a larger spreadsheet with which I've recieved much
help from this forum, I can make this available if anyone's intrested,
if I can figure out how to post it on this forum, The spreadsheet is
for DRIFTING and it automatically picks the top 16, sets up the
knockouts, final 16, final 8, final 4, final 2, and the winner.
(The grid I did above went daft when I posted it, I did another on the
attachment.)


+-------------------------------------------------------------------+
|Filename: GRID.jpg |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=22|
+-------------------------------------------------------------------+

--
kiki

"kiki" wrote
....
PS. this is part of a larger spreadsheet with which I've recieved much
help from this forum, I can make this available if anyone's intrested,
if I can figure out how to post it on this forum ...

As advised in the earlier thread, pl do not post any attachments.

You could try uploading your file(s) and then post the *link* to download in
your post for those interested to check it out.

There are 2 free filehosts that I know of, and use:

http://www.savefile.com/filehost/
http://flypicture.com/

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
---

Put in G3:
=IF(OR(F2=0,F4=0),"",IF(F2=F4,"Dead Heat - Re-run?","Car#
"&INDEX(B2:B4,MATCH(MAX(F2:F4),F2:F4,0))))

If you don't want the text: "Car# " in the result cell G3,
just delete the part: .. "Car# "& .. from the formula above, viz. use:

=IF(OR(F2=0,F4=0),"",IF(F2=F4,"Dead Heat -
Re-run?",INDEX(B2:B4,MATCH(MAX(F2:F4),F2:F4,0))))
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

Here's another Max

http://www.walagata.com/index.php

Haven't used it yet thyough.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Max" wrote in message
...
"kiki" wrote
...
PS. this is part of a larger spreadsheet with which I've recieved much
help from this forum, I can make this available if anyone's intrested,
if I can figure out how to post it on this forum ...

As advised in the earlier thread, pl do not post any attachments.

You could try uploading your file(s) and then post the *link* to download
in
your post for those interested to check it out.

There are 2 free filehosts that I know of, and use:

http://www.savefile.com/filehost/
http://flypicture.com/

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
---

Thanks, Bob ! I've bookmarked it <g
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--