First, you can use the SMALL function to find the 2nd smallest score.
e.g.:

=SMALL(G4:G32,2)

However, rather than using cond. formatting to 'hide' a zero, use an IF
statement to not return anything if D, E and F are blank, e.g.

=IF(SUM(D4:F4)=0,"",SUM(D4:F4))

Now the MIN function will work, as your cells will either contain the
SUM of your scores or be blank.

Second:

in a blank column (H?) enter this formula and copy down e.g. H4:H32

=IF(G4=MAX($G$4:$G$32),($J$7*3)+G4,"")

This will find the cell in G with the max value, and add your single
game handicap which has be trebled. OR-- You could just do the math in
K7 (=J7*3) and use that in your formula:

=IF(G4=MAX($G$4:$G$32,$K$7+G4,"")

Good Luck


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=474176