Pulling out the highest ten numbers from a list

J

joeafro84

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.
 
W

WhytheQ

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Range Selection - From Lowest 2 Highest Values? 2
how do i highlight the ten highest numbers in a range? 3
Selecting next to highest number in an array? 2
How do I find the highest of the most repeating values in a list ofnumbers ie. the max of the modes 1
find where a number belongs in a series of numbers 4
Displaying the Highest Value in a user-variable range of cells 1
Pulling larger numbers from group 3
Display the Highest, Second Highest, Third Highest and so on... 1

Top