Please explain this so that I can understand!
F Frank Kabel Dec 6, 2004 #2 Hi one way: =(SUM(A1:A100)-SUM(SMALL(A1:A100,{1,2})))/(COUNTA(A1:A100)-2)
N N Harkawat Dec 6, 2004 #3 =AVERAGE(SMALL(A:A,ROW(INDIRECT("1:"&COUNTA(A:A)-2)))) Array entered (ctrl+shift+enter)
N N Harkawat Dec 6, 2004 #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)
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)
