View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jatman jatman is offline
external usenet poster
 
Posts: 88
Default Calculating averages (olympic style)

good morning,

i have a worksheet and i need to calculate averages with a catch. i know
how to do basic averages and stuff. i need a formula to calculate the
following example:

data is in row 1. column a, b, c, d, e and f all have values entered in
them. i need the formula to drop the lowest value and give an average for
the remaining 5 only.

thank you,

jat jaswal