Thanks Max and Ragdyer for your replies, Max I've downloaded the link you provided and had a bit of a play and it works so good I'm now going to see if I can get it to automatically fill in the sheets for the knockout rounds which I can print off and give to the marshal for lining up the cars. I'll let you know how I get on,
Regards,
Kieran
Quote:
|
Originally Posted by Max
In Sheet1
Put in G2: =IF(COUNTBLANK(D2:F2)=0,MAX(D2:F2),"")
And if you want Sheet2 to display the results progressively ("live") as the
scores are input from the very first run onwards for the cars, instead of
waiting only until all 3 runs' scores are input (your original specs), just
change the formula in the starting cell Sheet1's G2 to:
=IF(COUNTBLANK(D2:F2)3,MAX(D2:F2),"")
(The rest of the set-up steps remain unchanged)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
-- |
Similar Threads
Threaded Mode
