what function do I use for excel to choose the 2nd highest number

E

ematboy

I want excel to determine the 2nd and 3rd highest numbers from a list of
numbers. What function do I use?
 
R

Roger Govier

Hi

=LARGE($A$1:$A$100,ROW(A1))
will find the largest number in the range A1:A100
as you copy down, ROW(A1) will become ROW(A2). and find the 2nd largest
, then the 3rd largest etc.
 

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

Finding location (or start cell) of highest consecutive values 3
IF Statement using several columns 3
Excel - Wich Function should I use? 1
2nd highest value. 1
Search row of numbers, find highest value. 2
Excel does not accept text format! 0
Index/Match Functions to Return Concatenated Response 4
Excel What Function shows value between highest and lowest number 2

Top