Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pulling out the highest ten numbers from a list
I am tracking out of stock items at work and I have a list of about 80
or so numbers, updated twice a week, and I would like to track the aisles with the highest number of out of stocks. Is there a way to pull out the ten highest numbers from this list and put them in a sorted list so that I can illustrate those aisles with the highest gaps. Thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pulling out the highest ten numbers from a list
Writing a macro is one route you could take: but I'd be tempted to
look into using a pivot table. You can set piv tables so that they are in descending order and only the top or bottom 10 items are showing. J On Mar 23, 4:31 pm, wrote: I am tracking out of stock items at work and I have a list of about 80 or so numbers, updated twice a week, and I would like to track the aisles with the highest number of out of stocks. Is there a way to pull out the ten highest numbers from this list and put them in a sorted list so that I can illustrate those aisles with the highest gaps. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average highest 16 numbers on a column of 32 numbers | Excel Worksheet Functions | |||
How do I find the 12 highest numbers in a row of 52 numbers | Excel Worksheet Functions | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Highest three numbers in a list | Excel Discussion (Misc queries) |