G
Guest
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
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