Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 10th 07, 09:40 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2007
Posts: 1
Default what function do I use for excel to choose the 2nd highest number

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

  #2   Report Post  
Old April 10th 07, 09:42 PM posted to microsoft.public.excel.worksheet.functions
bj bj is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,397
Default what function do I use for excel to choose the 2nd highest number

check out large() in help

"ematboy" wrote:

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

  #3   Report Post  
Old April 11th 07, 01:57 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,886
Default what function do I use for excel to choose the 2nd highest number

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.

--
Regards

Roger Govier


"ematboy" wrote in message
...
I want excel to determine the 2nd and 3rd highest numbers from a list
of
numbers. What function do I use?





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
which function to choose? J-EL Excel Worksheet Functions 0 November 9th 06 08:54 PM
Which function to choose? J-EL Excel Worksheet Functions 2 November 9th 06 07:46 PM
2 rows, highest No in row 1, then highest number in row 2 relating to that column, possible duplicates John Excel Worksheet Functions 3 August 11th 06 04:34 AM
Excel Formula - to calculate highest number from a set of numbers Emily Excel Worksheet Functions 1 June 27th 06 06:49 AM
In Excel, I need to now how to pick the second highest number in . Keith Excel Worksheet Functions 4 January 19th 05 04:23 PM


All times are GMT +1. The time now is 07:25 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017