Solved

Finding the second largest number in an array

Posted on 2014-07-24
2
172 Views
Last Modified: 2014-07-24
Hi experts,

Here is a quick question in excel.

We have a numerical array in A1:A100 and want to find out the second largest number. Is there a simple formula to do that?

Assume that we have found out the largest number and put it in B1 = Max(a1:a100), what can we do to use B1 too?

Thanks,
RDB
0
Comment
Question by:ResourcefulDB
2 Comments
 
LVL 92

Expert Comment

by:John Hurst
ID: 40218261
I think I would find the largest, put it and its index somewhere, then make a(index)=0 and run max again. The result will be the second largest. I am assuming all positive numbers for this exercise.
0
 
LVL 21

Accepted Solution

by:
Ejgil Hedegaard earned 500 total points
ID: 40218268
You find the second largest number using this formula
=LARGE(A1:A100,2)
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Microsoft Office 2010 is Microsoft's latest edition to their office productivity collection. It "promises to include rich and powerful new ways to deliver your best work". So to start off, I have to say that I'm slightly disappointed... That bei…
Today companies are subjected to more-and-more data, and it won't stop any time soon.  But there are obvious opportunities for reducing data, particularly data duplicated among companies.
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now