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
Cross-reference Insert Default Change 0
Pull Data With IF Statement And Sort. 1
Highlight Highest number 8
having excel create a new column in a highest to lowest format 4
Trying to create a report that will list unmatched records by Ticket Primary Key 0
want to list only rows with highest value of duplicates from a column 1
Numbered list problem 6

Top