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