View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default How to remove the top & bottom 10% from a list?

Referring to the post in General Question

Does anyone know how to remove the top & bottom 10 % from a list? such as
There is a list of values under column A, the number of values is not
defined, it can be as small as 10 values, and it can be as large as 6000
values and I would like to remove the 10% of maximum values and 10% of
minimum values from the lists, and store those numbers in column B.
Does anyone have any suggestion?
Thank you in advance
Eric