Pulling larger numbers from group

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How would I be able to pull 3 of the largest numbers in a list of 4 numbers
and list them in their own cells right next them.
IE.
100 100
80 80
20 70
70

Where the smallest number is left out but the three highest are displayed.
Thanks
 
Smint, here is one way, = LARGE(A1:A4,1) = LARGE(A1:A4,2) =
LARGE(A1:A4,3)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
That worked out great. Thanks

Paul B said:
Smint, here is one way, = LARGE(A1:A4,1) = LARGE(A1:A4,2) =
LARGE(A1:A4,3)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
Click to expand...
 
Your welcome
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
You must log in or register to reply here.

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

Calculate score from Scale 5
ID Values 4
Pulling cell information from one workbook to another 3
Offset and Small functions with blank rows? 0
Count function without double counting 1
lookup to return larger value 4
Pulling data from multiple spreadsheet 2
Formula equation for a conditional number - PART 2 - said better 3

Back
Top