Solved

Finding the second largest number in an array

Posted on 2014-07-24
2
179 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 95

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 22

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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

As freelancing is becoming more and more common in the tech industry, certain obstacles are proving to be a challenge to those who are used to more traditional, structured employment. This article is meant to help identify such obstacles and offer a…
This article will shed light on the latest trends when it comes to your resume building needs. For far too long, the traditional CV format has monopolized the recruitment market.
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

739 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