| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to remove the top & bottom 10% from a list?
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I remove bottom band on Excel page to see worksheets? | Excel Discussion (Misc queries) | |||
| Validation list with blanks at the bottom | Excel Discussion (Misc queries) | |||
| Identifying bottom of list | Excel Worksheet Functions | |||
| How do I remove "Fix" from my bottom toolbar? | Excel Discussion (Misc queries) | |||
| How do I remove a date at the bottom of an excel sheet? | Excel Worksheet Functions | |||
Threaded Mode
