G Guest Oct 27, 2003 #1 what i need is a formula, that will take the average of 3 out of 5 numbers , dropping the highest and the lowest numbers any help would be appreciated.
what i need is a formula, that will take the average of 3 out of 5 numbers , dropping the highest and the lowest numbers any help would be appreciated.
P Peo Sjoblom Oct 27, 2003 #2 One way =TRIMMEAN(A1:A5,2/COUNT(A1:A5)) or =TRIMMEAN(A1:A5,40%) -- Regards, Peo Sjoblom billy said: what i need is a formula, that will take the average of 3 out of 5 numbers Click to expand... , dropping the highest and the lowest numbers
One way =TRIMMEAN(A1:A5,2/COUNT(A1:A5)) or =TRIMMEAN(A1:A5,40%) -- Regards, Peo Sjoblom billy said: what i need is a formula, that will take the average of 3 out of 5 numbers Click to expand... , dropping the highest and the lowest numbers
B Bob Umlas Oct 27, 2003 #3 Nice, Peo -- didn't know of that function! Peo Sjoblom said: One way =TRIMMEAN(A1:A5,2/COUNT(A1:A5)) or =TRIMMEAN(A1:A5,40%) -- Regards, Peo Sjoblom numbers , dropping the highest and the lowest numbers Click to expand...
Nice, Peo -- didn't know of that function! Peo Sjoblom said: One way =TRIMMEAN(A1:A5,2/COUNT(A1:A5)) or =TRIMMEAN(A1:A5,40%) -- Regards, Peo Sjoblom numbers , dropping the highest and the lowest numbers Click to expand...
