How do I find top 3 in an unsorted list?

  • Thread starter Thread starter Guest
  • Start date Start date
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!
 
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

unsorted lookup 2
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
Finding the largest number help 7
MAX, MIN, MEAN, AVERAGE, MODE for multiple groups...how? 2
Average from 2 unsorted lists 3
An unsorted list in vlookup 2

Back
Top