Throwing Out top & lower percentages
 

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.

Throwing Out top & lower percentages
 

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


"Gary Gonzales" wrote:

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.

Throwing Out top & lower percentages
 

Perfect!

"Ron Coderre" wrote:

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


"Gary Gonzales" wrote:

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.