| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How do I drop the lowest 2 numbers and then average?
Please explain this so that I can understand!
|
|
#2
|
|||
|
|||
|
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! |
|
#3
|
|||
|
|||
|
=AVERAGE(SMALL(A:A,ROW(INDIRECT("1:"&COUNTA(A:A)-2))))
Array entered (ctrl+shift+enter) "nightlynik" wrote in message ... Please explain this so that I can understand! |
|
#4
|
|||
|
|||
|
Sorry you needed to exclude the smallest 2 entries
Change "small" to "large" so correct formula will be =AVERAGE(LARGE(A:A,ROW(INDIRECT("1:"&COUNTA(A:A)-2)))) Array entered (ctrl+shift+enter) "N Harkawat" wrote in message ... =AVERAGE(SMALL(A:A,ROW(INDIRECT("1:"&COUNTA(A:A)-2)))) Array entered (ctrl+shift+enter) "nightlynik" wrote in message ... Please explain this so that I can understand! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
