Another suggestions:
=(SUM(C1:K1)-MIN(C1:K1))/8 complete normally with ENTER
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"MedicEric" wrote in message
...
I want to average a series of grades (ex: C1 through K1), but want to drop
the lowest score in the series. However if 2 or more grades are the same,
I
want to drop only ONE of them. Additionally I wish to have that "dropped"
grade highlighted (conditionally formatted) in the list even though it is
not
calculated into the average.