Throwing Out top & lower percentages

G

Gary Gonzales

I have a list of numbers not in any particular order,

1, 33, 5 , 15, 22, 489, 100, 56, 17, 109, 367, 54, 20

I want to throw out the top 10% and botton 10% and do an average of the
remaining numbers, how do I do this?

p.s. I just provided 10% as an example, I need to be able to change this to
any percentage.
 
R

Ron Coderre

Check Excel Help for the TRIMMEAN function. I think it pretty much does what
you're looking for.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
G

Gary Gonzales

Perfect!

Ron Coderre said:
Check Excel Help for the TRIMMEAN function. I think it pretty much does what
you're looking for.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
Top