View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
MedicEric
 
Posts: n/a
Default Weighted Average

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.