Thread
:
How do I drop the lowest 2 numbers and then average?
View Single Post
#
2
Frank Kabel
Posts: n/a
Hi
one way:
=(SUM(A1:A100)-SUM(SMALL(A1:A100,{1,2})))/(COUNTA(A1:A100)-2)
--
Regards
Frank Kabel
Frankfurt, Germany
"nightlynik" schrieb im
Newsbeitrag ...
Please explain this so that I can understand!
Reply With Quote