How do I find top 3 in an unsorted list?

G

Guest

I have a list of data that is unsorted (and I cannot sort the data for
special reasons), but I want to find the 3 largest in a column...so its like
using the MAX function, but I need MAX 1, MAX 2nd, MAX 3rd. Here is an
example:

A B
Company 1 $200,000
Company 2 $100,000
Company 3 $500,000
Company 4 $550,000
Company 5 $212,000

I would like to pull in order the 3 largest
$550,000
$500,000
$212,000

Ideally I would like to pull the corresponding company also.

Please help me out. Thanks!
 
P

Peo Sjoblom

You can also use autofilter, from dropdown select top 10 and then change it
to top 3, that way you will get a filtered list according to your needs and
the companies will be filtered accordingly
 

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

Find last date of sold stock and sold price. 2
Find Last entry for Col in Multi column array using cell from another array. 1
Validation List 2
Top 5 in a List - Alterntive to Pivot Table 1
How do I match 3 different workbooks information for similar data? 2
MAX, MIN, MEAN, AVERAGE, MODE for multiple groups...how? 2
Finding the largest number help 7
An unsorted list in vlookup 2

Top